3

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

Improve this question
7
  • 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
    Commented Dec 2, 2011 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
    Commented Dec 2, 2011 at 18:08
  • Are you stuck with Windows? Linux has way more & better tools. How much data are you storing?
    – Aaron Brown
    Commented Dec 3, 2011 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
    Commented Dec 3, 2011 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
    Commented Dec 8, 2011 at 7:16

1 Answer 1

Reset to default
1

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.

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

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