Mysql database automatic backup restoration method

Mysql tutorial database tutorial automatic backup restoration method

I. Automatic Backup: Save the following code as a *. bat batch processing script, and then add Windows scheduled jobs, such as running at every day:
Set s = % date :~ 0, 4% % date :~ 5, 2% % date :~ 8, 2% % time :~ 1, 1% % time :~ 3,2% % time :~ 6, 2%
Mysqldump-u root-ppassword databasename> d: databasename _ % s % _ bak. SQL

Note: databasename indicates the database name and password. The system automatically backs up the database to the specified directory at the current date and time.

2. Restore the database: mysql-u root-p databasename <d: databasename. SQL

Backup solution 1: Use the mysqldump command to directly generate a complete. SQL File

Step 1: Create a batch

(Description: root is the default mysql user name, aaaaaa is the mysql password, and bugtracker is the database name)

------------ MySql_backup.bat success --------------------------------------------------------------------------------------

D:
Cd D: AppServMySQLbin
Mysqldump-uroot-paaaaaa bugtracker> E: DataBaseMysql_bugtracker_backupbugtracker_back. SQL
Exit

Bytes ------------------------------------------------------------------------------------------------------------------------

Step 2: Create a scheduled task

"Start" --> "Control Panel" --> "Administrative Tools" --> "Task Scheduler"

"Create A Basic Task" --> ---> "Daily" (pay attention to setting the hour, minute, and second following) --> ---- "Start a Program" --> "Browser" (locate and select the batch processing mySql_backup.bat you just created) --> ---> "Finish"

Corresponding restoration method

Create a process:

---------- MySql_restore.bat restart -----------------------------------------------------------------------------------------

D:
Cd D: AppServMySQLbin
Mysql-uroot-paaaaaa bugtracker <E: DataBaseMysql_bugtracker_backupbugtracker_back. SQL
Exit

Bytes -------------------------------------------------------------------------------------------------------------------------

Double-click it to automatically restore

Backup solution 2: Use the xcopy command to directly copy all the files of the corresponding database under the Mysql data DIRECTORY.

Create batch processing:

Certificate ------------------------------------------------------------------------------------------------------------------------------------------

Xcopy D: AppServMySQLdatabugtracker E: DataBaseMysql_bugtracker_backupbugtracker/e/h/d/y/r/v/f/k
Exit

Certificate -------------------------------------------------------------------------------------------------------------------------------------------

Corresponding restoration method

Copy the bugtracker folder in the E: DataBaseMysql_bugtracker_backup directory to the D: AppServMySQLdata directory, and overwrite all the bugtracker folders in this directory.