How to automatically back up MySQL in Linux

In Linux, you can use the crontab system to regularly back up MySQL Databases every day. The detailed steps are as follows: megava

In Linux, you can use the crontab system to regularly back up MySQL databases on a daily basis. The detailed steps are as follows: 1. Create the path to save the backup file/mysqldata # mkdir/mysqldata 2. Create the/usr/sbin/bakmysql file # vi/usr/sbin/bakmysql input rq = 'date + % Y % m % d 'tar zcvf/mysqldata/mysql1_rq.tar.gz/va

In Linux, you can use the crontab system to regularly back up MySQL databases on a daily basis. The detailed steps are as follows:

1. Create the path to save the backup file/mysqldata

# Mkdir/mysqldata

2. Create the/usr/sbin/bakmysql file.

# Vi/usr/sbin/bakmysql

Input

Rq = 'date + % Y % m % d'

Tar zcvf/mysqldata/mysql1_rq.tar.gz/var/lib/mysql

Or write it

Rq = 'date + % Y % m % d'

Mysqldump-all-databases-u root-p980405>/mysqldata/mysql1_rq.tar.gz

/Var/lib/mysql is the directory of your database files. Some users are/usr/local/mysql/data.

/Mysqldata/indicates the directory where the backup file is saved. This can be done according to your requirements.

3. Modify file attributes to make them executable.

# Chmod + x/usr/sbin/bakmysql

4. Modify/etc/crontab

# Vi/etc/crontab

Add

01 3 *** root/usr/sbin/bakmysql

Indicates that a backup is performed at three o'clock every day.

5. Restart crond.

#/Etc/rc. d/init. d/crond restart

Complete.

In this way, you can see such files in/mysqldata every day.

Mysql20100101.tar.gz