I am attempting to find a reliable service that does remote MySQL Database Backup.

Price is no object, unless it's absurdly expensive. I understand this question doesn't really have an answer, and I apologize for that.

Iam just looking for suggestions on ways I can check out for myself.

If this isn't the right place for this question, you can, you know, insult me or something :)

Thank you! Quintis

  • It's a good question. What OS locally? What edition (community, enterprise)? Prepared to try Percona XtraDB? Have local storage ready? Using InnoDB or MyISAM? – gbn Dec 2 '11 at 17:57
  • I'm using Windows 7 x64 Pro, the community (free) edition of MySQL (and workbench to manage it.) I've never heard of Percona XtraDB, but I'll check it out. We're planning on backing up to an external HD along with the remote backup plan, so yes. And finally, InnoDB. Thanks! :) – Quintis555 Dec 2 '11 at 18:08
  • Are you stuck with Windows? Linux has way more & better tools. How much data are you storing? – Aaron Brown Dec 3 '11 at 3:29
  • Yeah, I'm very stuck with Windows. It's for my company, I don't see them making the switch. It's about 60 gigs and growing. – Quintis555 Dec 3 '11 at 15:24
  • 1
    What's keeping you from finding a web hosting company that will allow you to rent a linux server? From there you could open up a firewall access between the two machines and run a simple shell script to copy the backups from your Windows computer to your rented distant linux computer. linode.com for example. – Craig Efrein Dec 8 '11 at 7:16

If you have a consistent connection to the external source then setting up replication would be the way to go. This way you ensure that all changes are automatically sent to the 'backup' (aka slave) server. You could still run a regular backup script to dump the data to an external HD as a failsafe in case someone 'drops' all the tables int the database. The book High Performance MySQL is a good source of information on replication setups.

  • That looks great! I'll check it out, and if it works, I'll make sure to mark yours as the answer. – Quintis555 Jan 13 '12 at 19:07

Not the answer you're looking for? Browse other questions tagged or ask your own question.