Windows universal mysql database backup script

In mysql, the most common method to back up a database is to copy a database. Let's take a look at the two mysql backup methods implemented by windows batch processing, which is very easy to use.

1. mysql mysqldump + bat processes files

Execute the mysql database backup script (bat file content)

The Code is as follows:	Copy code
@ Echo off Set host = localhost Set username = root Set passward = ansure Set database = weihe Set backup_path = D: \ db_backup \ Echo "Mysql Backup, please waitting" Mysqldump-h % host %-u % username %-p % passward % -- skip-lock-tables % database %> % backup_path % \ % database % _ % date :~ 0, 10%. SQL Echo "OK! "

2. xcopy: Create a batch file backup. dat and enter the following code:

The Code is as follows:	Copy code
Net stop mysql Xcopy "C: \ Program Files \ MySQL Server 5.0 \ data \ piaoyi \ *. *" D: \ db_backup \ % date :~ 0, 10% \/y Net start mysql