First step: Define your backup directory on your Linux server:
The code is as follows |
Copy Code |
Mkdir/var/lib/mysqlbackup Cd/var/lib/mysqlbackup |
The second step: The following is the most important step, is to write a scheduled backup script.
The code is as follows |
Copy Code |
VI dbbackup.sh
|
The code file is as follows
The code is as follows |
Copy Code |
#!/bin/sh # MySQL Data backup script # # Use mysqldump--help,get more detail. # Bakdir=/root/back/ysqlbackup Logfile=/root/back/mysql/mysqlbak.log Date= ' Date +%y%m%d%h%m%s ' echo "" >> $LogFile echo "" >> $LogFile echo "-------------------------------------------" >> $LogFile echo $ (date + "%y-%m-%d%h:%m:%s") >> $LogFile echo "--------------------------" >> $LogFile CD $BakDir dumpfile= $DATE. sql gzdumpfile= $DATE. sql.tar.gz /usr/local/bin/mysqldump-u user-pname--database-h 127.0.0.1 db> $DumpFile echo "Dump done" >> $LogFile Tar czvf $GZDumpFile $DumpFile >> $LogFile 2>&1 echo "[$GZDumpFile]backup success!" >> $LogFile Rm-f $DumpFile #cd $BakDir/daily CD $BakDir echo "Backup done!" echo "Please Check $BakDir directory!" echo "Copy it to your local disk or FTP to somewhere!!!" Find $BakDir-ctime +30-exec rm {}; echo "Delete file over the days" |
Friendly tip: user,name and DB Please change according to your situation
Save the exit, and then give the file the executable permission:
The code is as follows |
Copy Code |
#chmod 777 mysqlautobackup.sh |
Perform backup script code with crontab:
--------------------------------------------------------------------------------
Crontab-e
--------------------------------------------------------------------------------
If you back up 3 o'clock in the afternoon 20 daily, add the following code,
Code:
--------------------------------------------------------------------------------
The code is as follows |
Copy Code |
* * */var/lib/mysqlbackup/dbbackup.sh |
This is done, every day will regularly help you back up the MySQL database.