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.
Comments
http://sourceforge.net/projects/automysqlbackup/ is quite good. Then either FTP or Rsync the backups.
@Francisco Do you backup your shared MySQL? If you do, then I don't need to think about that.
Regardless of what a provider does or claims to do, if this data is important to you. You should back it up
I guess you are right. There is never too careful.
I use the MySQL backup in web min. Works well and takes care of scheduling and firing off any errors.
Just run 'mysqldump --single-transaction' whenever your lowest load is, for me it's roughly 6AM UTC.
From there, you could use something like s3cmd to push backups to Amazon S3, or use Duplicity to send encrypted backups to FTP directories; both have worked great for me
This.
I also do mysqldumps of the entire system so that I can recover the whole lot quickly in case of some major drama.
Yes. I just tried Duplicity. Really a great tool. Thanks for the suggestions.
This one has been saving my butt for years:
http://www.ameir.net/blog/archives/48-MySQL-Backup-to-FTP-and-Email-Shell-Script-for-Cron-v2.2.html
we do nightly backups with innobackupex.
we keep a week of rolling backups.
Francisco
Is there a good method to do a off-site mysql backup? I am wondering if mysqldump will eat up too much resources?
Thanks
Nice read for what i usually use mydumper + pigz for multi threaded backup and multi threaded compression backups (up to 10x times faster mysql backups + up to 33x times faster gzip compression) http://www.lowendtalk.com/discussion/comment/176248#Comment_176248
Hello,
Use AutoMySQLBackup.It has some great features to: backup a single database, multiple databases, or all the databases on the server; each database is saved in a separate file that can be compressed (with gzip or bzip2); it will rotate the backups and not keep them filling your hard drive (as normal in the daily backup you will have only the last 7 days of backups, the weekly if enabled will have one for each week, etc.).