Making a DB Backup and send it to another server

adumith · 03-03-2015, 03:26 PM

Hello everyone;

At this time I need to make a sh script to make a db backup an send it to another server.

Thinking about this, I think I have to:
1.- Make a connection beetween the servers without password
2.- The scrip must to do:
a.- Make the mysqldump
b.- Put it in a gzip file
c.- Send througth scp the gzip file and ONLY when the copy has done the script have to delete the files that are 3 days old.

Could you help me with this?

Do you consider that is a good idea or you have a better one?

Thanks in advance.

Kgeil · 03-03-2015, 04:24 PM

This looks like a really appealing option: http://wiki.bacula.org/doku.php?id=a..._backups:mysql

I haven't tried it yet, but it's on my to-do list, about 2 weeks out.

HTH,

Kevin

Habitual · 03-03-2015, 04:31 PM

Code:

mysqldump -h <ip> -u<user> p<pass> <db_name> > /path/to/save/file.sql
tar -czf archive_name-$(date +%F).tar.gz /path/to/save/file.sql
for i in `seq 2 31` ; do rm archive_name-$(date +"%m%d%Y" --date="$i days ago") ; done

You should have a user granted perms in mysql just for this purpose or use an existing one (if 'user'@'host' value allows it.
I would NOT use 'user'@'%' like so many are inclined to do)

Other solutions may be more dialed in, I'm tired.
Shout if you need help.

References:
http://www.cyberciti.biz/tips/backup...using-ssh.html
http://bash.cyberciti.biz/backup/bac...base-server-2/