MySQL regularly backs up the database shell

One, prepare the shell script.

View copy print?

2. vi/home/zhangy/database_bak.sh
6. #!/bin/sh
8. # File:/home/zhangy/database_bak.sh
10. # Database Info bakupmysql TANK 2009/11/04
12. db_user="root" #用户名
14. db_pass="********" # password
16. Db_name="MyBlog" # The data name to be backed up
20. <span id=more-161></span># Others VARs
22. Date= ' Date+%y_%m_%d ' # dates to be backed up
24. Yesterday= 'date-d yesterday +%y_%m_%d ' # Delete yesterday's backup
28. bin_dir="/usr/local/mysql/bin"
30. bck_dir="/home/zhangy/database_bak" # Backup path
34. CD $BCK _dir
38. # Delete Previous backup of this database, because my Linux also has 2G hard disk space, depressed.
40. If [ -F $YESTERDAY$DB _name". sql"]
42. Then
44. Rm-f $YESTERDAY$DB _name". sql"
46. Fi
50. # Backup
52. ${bin_dir}/mysqldump--opt-u${db_user}-p${db_pass} ${db_name} > ${bck_dir}/${date}${db_name}.sql

vi/home/zhangy/database_bak.sh #!/bin/sh # File:/home/zhangy/database_bak.sh # Database Info bakupmysql  TANK 2009 /11/04 db_user= "root"   #用户名 db_pass= "********"   &NB Sp                          ,         &NB Sp                 # password Db_name= "MyBlog"             &NB Sp                          ,         &NB Sp

    # The data name to be backed up# Others VARs date= ' date +%y_%m_%d ' # to back up the date yesterday= ' date-d yesterday +     

%y_%m_%d ' # Delete yesterday's backup bin_dir= "/usr/local/mysql/bin" bck_dir= "/home/zhangy/database_bak" # Backup path
CD $BCK _dir # Delete Previous backup of this database, because my Linux also has 2G hard disk space, depressed. If [-F $YESTERDAY $db_name ". sql"] then rm-f $YESTERDAY $db_name ". sql" FI # backup ${bin_dir}/mysqldump--opt-u${db_user}- P${db_pass} ${db_name} > ${bck_dir}/${date}${db_name}.sql

Second, regular implementation
Put the shell inside the crontab.

# See if Crond is started
[Email protected] cron]# Ps-e|grep Crond
21519? 00:00:00 Crond

# Open Crontab
[Email protected] cron]# CRONTAB-E
# Add a line inside
* * * * */home/zhangy/database_bak.sh

# Check to see if you've added
[Email protected] cron]# crontab-l
#
# do not EDIT this FILE manually!! Use Crontab-e INSTEAD.
#

# <minute>

* * * * * */usr/sbin/run-cron/etc/cron.hourly
* * * * */usr/sbin/run-cron/etc/cron.daily
* * 0/usr/sbin/run-cron/etc/cron.weekly
1 * */usr/sbin/run-cron/etc/cron.monthly
* * * */home/zhangy/www/bb.php
* * * * */sbin/shutdown-h now
* * * * */home/zhangy/database_bak.sh

And then quit.

MySQL regularly backs up the database shell