Linux timed backup MySQL database file

1, set timer: terminal-typed: crontab-e command

2, then write to * * * */home/db_bak_file/dbbak.sh >>/home/db_bak_file/backdbinfo. This statement works by executing the script under/home/db_bak_file/dbbak.sh at 23 o ' Day, and keeping the log in the/home/db_bak_file/backdbinfo text.

3, Exit Edit: ESC +: + W + q

4, the backup script dbbak.sh content is:

Nowdate= ' Date ' +%y%m%d "'
Mysqldump-u root--password= Database password database name >/home/db_bak_file/${nowdate}

The new file that is backed up is the date of the backup day.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Linux timed backup MySQL database file