MYSQL basic commands and useful links and backup methods

 

Backup

How to Download and Install MySQL in Windows 11/10 (thewindowsclub.com)

https://dev.mysql.com/downloads/file/?id=523568

https://sqlbak.com/blog/how-to-backup-mysql-database-on-windows/

https://serverguy.com/servers/how-to-backup-mysql-database/

https://www.jotform.com/blog/how-to-backup-mysql-database/

https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/mysqldump-sql-format.html

https://www.sitepoint.com/backing-up-mysqldump/

useful mysql and linux admin tool via website

https://webmin.com/

my sql commands:

To connect mysql instance:

open cmd or run command

Go to bin folder as above

C:\Windows\system32>c:  

C:\Windows\system32>cd C:\Program Files\MySQL\MySQL Server 8.0\bin  

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u root -p  

mysql> select version();  

mysql> show databases; 

mysql>create database testmysql;

mysql>use testmysql;

mysql> create table test(testid int,testdesc char); 

mysql> insert into test select 5,'t';  

mysql> select * from test;    

To take backup of my sql database

C:\Windows\system32>c:  

C:\Windows\system32>cd C:\Program Files\MySQL\MySQL Server 8.0\bin  

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql --user root  testmysql > testmysql_bk.sql; 

C:\Program Files\MySQL\MySQL Server 8.0\bin>dir