New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
MySQL Backup Script/Open Source Website
TheRealMakan
Member
in General
So I own a few MySQL databases on lots of servers. I'm currently using MyRepono to back it up and they charge 1 cent every server backup I make and at any time I make it.
Anybody know of any software I can install on a dedicated backup software, have it run, (Cron jobs?) and work on multiple servers at once?
Comments
Why not just dump your full databases, encrypt, send over to x? The other option is copying at a file system level.
I think there might be further stuff geared towards what your asking directly. Just my two cents.
I would not recommend copying at file system level because of the data that's in RAM. Dump the DB, encrypt, and send is the better option.
https://rclone.org/
automysqlbackup?
https://sourceforge.net/projects/automysqlbackup/
Thanks for the tips everyone, I'll look into them.
there is a lot of shell script that dump mysql and send/upload to ftp server.
you can also set up master-slave replication.
from what I see , it's real time duplicating , or just few seconds delay, anyway , I couldn't notice any delay in my test.
I feel replication is much better than mysqldump backup script as you can only cron it every certain time.
I just dump the mysql db using a cronjob and then upload it to OVH Cloud Storage using swift:
https://gist.github.com/anonymous/7061449508acaf18c8eb2461b1d62074
You could probably just push it somewhere using scp aswell.