How to automatically backup Mysql under Linux _mysql

Linux can use the crontab system to regularly back up the MySQL database every day, the following are detailed steps:

1, create the path to save the backup file/mysqldata

#mkdir/mysqldata

2. Create/usr/sbin/bakmysql files

#vi/usr/sbin/bakmysql

Input

rq= ' Date +%y%m%d '

Tar Zcvf/mysqldata/mysql$rq.tar.gz/var/lib/mysql

or write

rq= ' Date +%y%m%d '

Mysqldump–all-databases-u root-p980405 >/mysqldata/mysql$rq.tar.gz

/var/lib/mysql is the directory of your database files, some users are/usr/local/mysql/data, everyone may be different

/mysqldata/represents the directory where the backup files are saved, and everyone can do it according to their own requirements.

3, modify the file properties to make it executable

# chmod +x/usr/sbin/bakmysql

4. Modify/etc/crontab

#vi/etc/crontab

Add the following

3 * * * root/usr/sbin/bakmysql

Indicates a backup is performed 3 o'clock daily

5. Reboot Crond

#/etc/rc.d/init.d/crond Restart

Complete.

So every day you can see a file like this in/mysqldata.

Mysql20100101.tar.gz