Shell script to backup MySQL database server<\/h2>\n
Following is the shell script. It will dump all database to \/backup\/mysql and later it will upload to FTP server. You need to setup correct username and password before using the script:<\/p>\n
#!\/bin\/bash\r\n#\r\n## go to folder where to backup\r\n#\r\ncd \/root\/scripts\/backups\/\r\n\r\nfor i in mon_site mon_forum mon_blog; do\r\n\r\n## Save mysql databases in .sql files\r\nmysqldump -uroot -pmonpass $i > ${i}_`date +\"%Y-%m-%d\"`.sql\r\n\r\n## Compression with tar.bz2 (best rate compression)\r\ntar jcf ${i}_`date +\"%Y-%m-%d\"`.sql.tar.bz2 ${i}_`date +\"%Y-%m-%d\"`.sql\r\n\r\n## delete unzipped exports\r\nrm ${i}_`date +\"%Y-%m-%d\"`.sql\r\ndone\r\nlftp -u $FTPU,$FTPP -e \"mkdir \/mysql\/;cd \/mysql\/; mput \/root\/scripts\/backups\/*; quit\" $FTPS<\/pre>\nSave script as \/home\/your-name\/backup_bdd.sh file. Setup executable permission:<\/p>\n
$ chmod +x \/home\/your-name\/backup_bdd.sh<\/pre>\nTo backup MySQL, enter:<\/p>\n
\/home\/your-name\/backup_bdd.sh<\/pre>\nOR<\/p>\n
sudo \/home\/your-name\/backup_bdd.sh<\/pre>\nClean older files :<\/h3>\n
To clean old sql files we create a bash\/script file clean_backups.sh :<\/p>\n
#!\/bin\/bash\r\n#\r\n## Delete Files older than 5 days\r\n#\r\nfind \/root\/scripts\/backups\/ -type f -mtime +4 -delete<\/pre>\nRun MySQL backup script as cron job<\/h2>\n
![\"cronjob\"](\"http:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/cronjob.jpg\")
<\/a><\/p>\n