MySQL backup script

Requirements: Back up the MySQL database and upload the data backed up files to the FTP server
FTP Server IP Address: 192.168.6.9
FTP Server account/password: test/test123

1. Root user creates backup script path:

$ mkdir /opt/databak$ cd /opt/databak

2. Create a backup script:

#vi /opt/databak/dbbak.sh #!/bin/shtimedate=$(date +%Y%m%d%H%M%S) dbname=rootdbpasswd=1334babydbname=bwangbabydbhome=/opt/databakmysqldump -u$dbname -p$dbpasswd $babydbname >$babydbhome/$babydbname-$timedate.sqlsleep 5find $babydbhome/*.sql -mtime +30 -exec rm -rf {} \; cd $babydbhomeftp -v -n 192.168.6.9 >>$babydbname-$timedate.log << EOF      #将上传过程中产生的打印信息写到$babydbname-$timedate.log里面,后面判断是否成功要用user test test123binaryhashput $babydbname-$timedate.sql $babydbname-$timedate.sqlbyeEOF

Execute permissions on the dbbak.sh script and do a scheduled task
20 0 * * * /bin/sh /opt/databak/dbbak.sh

MySQL backup script