MySQL database Regular automatic backup script, mysql database script
The most important thing for a Web system is the security and integrity of the database.
It is very important to back up data regularly. Do not be lazy on this issue. If your important data is lost, it will make you cry.
Export table structure and data mysqldump-uroot-pmypassword -- databases fansunion -- result-file =/var/www/backup/fansunion-table-and-data. SQL
Export only the table structure mysqldump-uroot-pmypassword -- databases fansunion -- no-data -- result-file =/var/www/backup/fansunion-table. SQL
Export data only mysqldump-t-uroot-pmypassword -- databases fansunion -- result-file =/var/www/backup/fansunion-table-and-data. SQL
Import Data source/var/www/backup/fansunion-table. SQL
Regular backup use crontab regular backup mysqlcrontab-e 17 every day, execute the backup script 0 17 ***/var/www/autobackup-mysql.sh (online said, can be placed by the user, but try again, no, '0 17 *** root/var/www/autobackup-mysql.sh ')
Autobackup-mysql.shnow = 'date "+ % Y % m % d % H % M % S" 'file = "/var/www/backup/fansunion-table-data-" $ now". SQL "/usr/local/mysql/bin/mysqldump-uroot-pmypassword -- databases fansunion-t> $ file
Remember, the full path must be used for mysqldump. References: http://bbs.chinaunix.net/thread-512166-1-1.html
0 17 ***/root/backup/autobackup-mysql.sh
First: http://fansunion.cn/article/detail/58.html