Finally let the server back up the MySQL database every morning and automatically pack, and delete 5 days ago backup files. Share as follows.
1. Environment: Windows Server 2003 + Apache 2.0 + PHP5 + MySQL 4.0.26.
2. Suppose the PHP installation directory is d:/php, the MySQL installation directory is d:/mysql.
3. Create a directory WinRAR under d:/php and copy WinRAR.exe and Rarreg.key from your WinRAR installation directory to D:/php/winrar.
4. Establishment of document Mysql_backup.php under d:/php:
/*/////////////////////////
#FileName: mysql_backup.php
#Author: Faisun
#Website: http://www.softpure.com
////////////////////////*/
Save the directory with a backslash. You need to build it manually.
$store _folder = ' D:\databse_backup ';
User name and password
The account must have the right to operate [all] databases and file
Otherwise, some databases cannot be backed up.
$db _username = "root";
$db _password = "";
$time =time ();
$nowdir = "$store _folder\\". Date ("Ymd", $time). "";
if (File_exists ("$nowdir. rar")) die ("File exists.\n");
@mkdir ($nowdir);
mysql_connect ("localhost", "$db _username", "$db _password");
$query =mysql_list_dbs ();
while ($result =mysql_fetch_array ($query)) {
System (DirName (__file__). ' \.. \mysql\bin\mysqldump--opt '. ' $result [Database]
-u{$db _username} ". ($db _password?) -p{$db _password} ":" ". >
$nowdir \ $result [database].sql ");
echo "Dumping database" $result [database] ' ... \ n ';
}
echo "\nwinrar loading...\n";
System (DirName (__file__). " \\WinRAR\\WinRAR.exe a-ep1-r-o+-m5-df \ "$nowdir. Rar\"
"$nowdir" ");
Delete a file 5 days ago
@unlink ("$store _folder\\". Date ("Ymd", $time -86400*5). ". RAR ");
echo "\nok!\n";
>
5. The d:/php establishes the document Mysql_backup.bat, the content is only one sentence:
Php.exe mysql_backup.php
6. Double-click the bat file to run, if you can back up, OK, next add the task plan.
7. Add the D:/php/mysql_backup to the task schedule and select the time each day. According to the monitoring results of the server, 5-8 hours per morning for the low peak traffic. Due to the cleanup of some databases at 5-7, the time can be set at 8 o'clock in the morning.