How to: remotely backup your DB (bash script)

[masterbator]

hello mateys,
i've put up some basic shell commands (with the help of our beloved lord google the mighty) that will allow you to backup your DBs locally, gzipped it and then send it thru ftp to safe place you've picked

#!/bin/bash
mysqldump -uYOURUSERNAME -pYOURPASS -hlocalhost YOURDBNAME > /your/path/backup-`date +%d%m%y`.sql
tar -zcvf /your/path/zippedbackup-`date +%d%m%y`.tgz /your/path/*.sql

cd /your/path
HOST='YOURFTPHOST'
USER='YOURFTPUSERNAME'
PASSWD='YOURFTPPASS'
ftp -n -v $HOST << EOT
binary
user $USER $PASSWD
prompt
put zippedbackup-*
bye
EOT

rm -rf /your/path/*

exit 0

that's it. you can run it automatically using cron or nohup.
also don't forget to chmod it first to 755 so that the script can be executed

hope that helps.

masterbator Reviewed by masterbator on 27th Nov 2011. How to: remotely backup your DB (bash script) hello mateys, i've put up some basic shell commands (with the help of our beloved lord google the mighty) that will allow you to backup your DBs locally, gzipped it and then send it thru ftp to safe place you've picked #!/bin/bash mysqldump -uYOURUSERNAME -pYOURPASS -hlocalhost YOURDBNAME > /your/path/backup-`date +%d%m%y`.sql tar -zcvf /your/path/zippedbackup-`date +%d%m%y`.tgz /your/path/*.sql cd /your/path HOST='YOURFTPHOST' Rating: 5

[Gavo]

Be very carefull what you put here, I would even remove that line.

rm -rf /your/path/* 

[masterbator]

Be very carefull what you put here, I would even remove that line.

rm -rf /your/path/* 

well i put that command there intentionally, that's just temporary folder, so once the ftp transfer has been completed, the local backup folder (which was /your/path/) is empty and ready to be filled again with newest backup files

[yuvraj]

ftp command not found error

[masterbator]

ftp command not found error

you need to install ftp on your server

[yuvraj]

: command not found:
: command not found:
: command not found1:
: command not found4:
: Name or service not known
Not connected.
Not connected.
Not connected.
?Invalid command
: command not found2:
: numeric argument required 0

i am able to login in ftp account
so it mean ftp is installed and working
remote ftp account with putty

[masterbator]

try login on ssh
then type ftp

[LuDo8]

@Masterbator, I don't need the FTP, I will manually download it everyday, but I just need the script to zip the site folders and mysql into one location. Did I modify your script correctly? And this is for Centos 5-6?

I'm using fake user/pass and locations, so no worries.

#!/bin/bash
mysqldump -uLudo8 -pludo8 -hlocalhost ludodb > /var/www/mysite-`date +%d%m%y`.sql
tar -zcvf /var/www/mysite/backups-`date +%d%m%y`.tgz /var/www/mysite/backups*.sql



exit 0

Also is it -uLudo8 or -u Ludo8?

[masterbator]

@Masterbator, I don't need the FTP, I will manually download it everyday, but I just need the script to zip the site folders and mysql into one location. Did I modify your script correctly? And this is for Centos 5-6?

I'm using fake user/pass and locations, so no worries.

#!/bin/bash
mysqldump -uLudo8 -pludo8 -hlocalhost ludodb > /var/www/mysite-`date +%d%m%y`.sql
tar -zcvf /var/www/mysite/backups-`date +%d%m%y`.tgz /var/www/mysite/backups*.sql



exit 0

this works for any linux distro mate

i think this script will work for your purpose:

#!/bin/bash
mysqldump -uLudo8 -pludo8 -hlocalhost ludodb > /var/www/yoursite/DB-`date +%d-%m-%y`.sql
tar -zcf /var/www/backupfolder/yoursitefull-`date +%d-%m-%y`.tgz /var/www/yoursite/*



exit 0

then you just have to go to /var/www/backupfolder/
and download your full backup (DB+site) from there (the yoursitefull.tgz file)

Also is it -uLudo8 or -u Ludo8?

doesn't matter, it will work with or without a space