Regular MySQL backup is an important task, but manual operations are too cumbersome and difficult to avoid any omissions. You can use the following method to regularly back up data. ◆ 1. Create a backup folder # cdwww # makedirbackup ◆ 2. Write a running script # Write the following content to viautobackup: filename 'date + % Y % m % d' mysql _ bin_dirmy
Regular MySQL backup is an important task, but manual operations are too cumbersome and difficult to avoid any omissions. You can use the following method to regularly back up data. ◆ 1. Create a backup folder # cd/www # makedir backup ◆ 2. Write a running script # vi autobackup to write the following content: filename = 'date + % Y % m % d' mysql_bin_dir/my
Regular MySQL backup is an important task, but manual operations are too cumbersome and difficult to avoid any omissions. You can use the following method to regularly back up data.
◆ 1. Create a backup folder
# Cd/www
# Makedir backup
◆ 2. Compile the running script
# Vi autobackup
Write the following content:
Filename = 'date + % Y % m % d'
Mysql_bin_dir/mysqldump-opt dataname-u user-ppassword | gzip>/www/mysqlbackup/name1_filename.gz
Save and exit
Note:
(1) mysql_bin_dir: bin path of mysql;
(2) dataname: Database Name;
(3) user: Database user Name;
(4) password: User password;
(5) name: ID of the prefix of the backup file.
In this example, the MySQLDatabase is automatically created and stored in gzipcompressed format. The file name is name20080101.gz.
◆ 3. Add execution permissions for the script
# Chmod + x autobackup
◆ 4. Let crontab complete the tasks that are periodically executed
In this step, the Redhat method will be different and will be provided later.
Edit crontab:
# Vi/etc/crontab
Add the following to the last line:
01 5 *** root/www/autobackup
Run the script at every day, or change 5 to another specified time.
Redhat method:
The crontab of Redhat calls four directories by time (/etc/cron. hourly: hourly;/etc/cron. daily: daily;/etc/cron. weekly: weekly;/etc/cron. monthly: indicates how the script runs every month.
In Redhat, you only need to copy the edited script to the corresponding directory.
◆ 5. Restart crontab
#/Etc/rc. d/init. d/crond restart
Complete.