Manual and scheduled backup steps for MySQL database

Manual backup

1) cmd console: mysqldump -uroot -proot database name [table name 1, table name 2...] > file path

For example: back up the demo database to E:\test\demo.bak

mysqldump -uroot -p123456 demo > E:\test\demo.bak #123456 is the database password

If you want to back up the test1 table of the demo library

mysqldump -uroot -p123456 demo test1 > E:\test\demo.test1.bak

How to restore our data using the backup file mysql console?

2) MySQL console: source E:\test\demo.test1.bak

3) Specific operation screenshots:

Timer backup

1) Write the command to back up the database into the bat file

Create a mytask.txt file and insert the following content: F:\MySQL\bin\mysqldump -uroot -p123456 demo test1 > E:\test\demo.test.bak , then change the suffix to .bat

Note: The content of mytask.bat is "F:MySQL\bin" (for your own MySQL bin directory)

If your mysqldump.exe file path has spaces, be sure to use " " include

2) Then use the task manager to call the bat file regularly, make mytask.bat a task, and call it regularly

Steps: Control Panel>Task Schedule>Create Basic Task

The above is the details of the manual and scheduled backup techniques of MySQL database. For more information about manual and scheduled backup of database, please pay attention to other related articles on 123WORDPRESS.COM!