+ First, we would need to add the FTP login details in .netrc file. If this file is not present then you can create new .netrc file. Please note that the permission of this file should be 600.<\/p>\n
——————-
\nmachine IPADDDRESS
\nlogin username
\npassword password
\n——————-<\/p>\n
+ Create a backup script and put the following content in the file.<\/p>\n
————————
\n!\/bin\/bash
\n### MySQL Setup ###
\nMUSER=”root”
\nMPASS=”mysqlpassword”
\nMHOST=”127.0.0.1″
\nMYSQL=”$(which mysql)”
\nMYSQLDUMP=”$(which mysqldump)”
\nBAK=”\/backup\/mysql”
\nNOW=$(date +”%F”)
\nDEL=$(date –date=’4 days ago’ +%F)
\n### FTP Server Info ###
\nFTPU=”FTPusername” # ftp user
\nFTPP=”FTPpassword” # ftp password
\nFTPS=”IPaddress” # ftp server name\/ip address<\/p>\n
[ ! -d $BAK ] && mkdir -p $BAK || \/bin\/rm -f $BAK\/*<\/p>\n
DBS=”$($MYSQL -Bse ‘show databases’)”
\nfor db in $DBS
\ndo
\ncd $BAK
\n$MYSQLDUMP $db >$db.sql
\ndone
\n# make sure ftp server has mysql directory to store database
\nlftp -u $FTPU,$FTPP -e “mkdir mysql\/$NOW;cd mysql\/$NOW; mput \/backup\/mysql\/*; quit” $FTPS
\nlftp -u $FTPU,$FTPP -e “cd mysql;rmdir $DEL;quit” $FTPS
\necho “Completed”
\n————————<\/p>\n
+ Give the execute permission to the script and then execute the script. Please make sure that there is no error during the execution.<\/p>\n
+ Add the script in cron to run on daily basis.<\/p>\n","protected":false},"excerpt":{"rendered":"