PHP Backup MySQL Instance program

#将所有备份文件备份到指定的目录, such as/backup/mysql_data_backup

The code is as follows	Copy Code
Mkdir/backup/mysql_data_backup-p Cd/backup/mysql_data_backup Wget/backmysql.txt-o backmysql.php chmod +x backmysql.php Crontab-e

Add a row of tasks

The code is as follows	Copy Code
0 * * */usr/bin/php/backup/mysql_data_backup/backmysql.php

To use PHP to perform backup commands every night 0:13

The code is as follows	Copy Code
#!/usr/bin/php < PHP Generate Save Directory $path = DirName (__file__). '/'. Date ("Ym"); $filename = sprintf ("%s/%s.sql.gz", $path, Date ("Ymdhis")); if (!is_dir ($path)) mkdir ($path); Export and compress all databases $cmd = sprintf ("/usr/bin/mysqldump-uroot-ppassword--all-databases | /bin/gzip >%s ", $filename); echo "BACKUPING...N"; ' $cmd '; echo "Backup DONE.N";

Note that this is only a plan for information processing, and if you want to execute PHP files we need to write one ourselves.