Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question

closed as off-topic by Mark Storey-Smith, dezso, Max Vernon, Mat, RolandoMySQLDBA Aug 29 '13 at 23:57

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Mark Storey-Smith, dezso, Max Vernon, Mat, RolandoMySQLDBA
If this question can be reworded to fit the rules in the help center, please edit the question.

    
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

1 Answer 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.

share|improve this answer
    
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.