Example of setting up Mysql automatic backup under Ubuntu _mysql

1. Create a path to save the MySQL backup file/mysqldata
#mkdir/mysqldata

2. Create/usr/sbin/bakmysql files
#nano/usr/sbin/bakmysql

Input:

Copy Code code as follows:

#!/bin/sh
Name= ' date+%y%m%d '
mysqldump--all-databases-uroot-p Password >/var/mysqlbak/mysql.sql

Note:--all-databases to back up all the databases to the Mysql.sql file under Mysqlbak, if you replace--all-databases with test, only the test database is backed up.

3, modify the file properties to make it executable
# chmod +x/usr/sbin/bakmysql

4. Modify/etc/crontab
#nano/etc/crontab

Add the following:
3 * * * root/usr/sbin/bakmysql
Indicates that a backup is scheduled to be performed 3 o'clock every day.

5, restart Crond
#/etc/init.d/cron Restar

Complete.