Practical Methods for automatic MySQL database backup in Linux

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.