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