MYSQL backup policy

1. Create a directory for saving the backup file/mysqldata
# Mkdir/mysqldata

2. Create the/usr/sbin/bakmysql file.
# Vi/backup/bakmysql. sh
Input (cyclically)
Tar zcvf/mysqldata/mysql _ 'date-d today when running w'.tar.gz/var/lib/mysql

Or write it
Mysqldump -- all-databases-u root-p password>/mysqldata/mysql _ 'date-d today + % W'. SQL
/Var/lib/mysql is the directory of the database file. 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. sh

1 2 Next Page

[Content navigation]
Page 1: MYSQL backup policy	Page 1: MYSQL backup policy