Hassle-free backup for MySQL under Windows
-
Looking for recommendations for an automated MySQL backup solution a Windows-only shop will be comfortable with. I'm setting up a MySQL database for a client that will be hosted on a Windows machine, and need a backup system that will be slightly more elegant than putting something together using e.g. mysqldump and scheduled tasks. This database is just a small part of a whole bunch of systems the local IT staff will be taking care of, so I would like to recommend something that will mesh well with the way things are done in the Windows world. There's no official budget for this, but a paid solution is not out of the question.
-
Answer:
What do mysqldump and scheduled tasks fail to give you? (BTW you might want a master/slave setup, and to take the backup from the slave).
Dr Dracator at Ask.Metafilter.Com Visit the source
Other answers
So you're looking for not using scripts, something point and clicky, with active directory integration? Most backup products support MySQL. Is there a reason you can't use those?
devnull
Point and click is just the ticket - I know I could be covered with a dump, but the people using this are not really fans of the command line: giving them something they like will ultimately save me from remote telephone debugging. As to backup products that will support MySQL, a recommendation for one you know and like is exactly the kind of thing I am looking for.
Dr Dracator
http://www.webyog.com/en/. Sounds like what you really want is SQL Server, though.
Leon
Changing the database at this point is not an option - it would be a major rewrite+testing headache, plus other (more linux-friendly) people are happily using the system and wouldn't care to move to SQL Server.
Dr Dracator
I have done this for quite a few places, use a scheduled task to dump selected databases/tables in known locations (I chose the early hours when no one was active), then upload those to other locations if required. Also easy to trim backups so as keep the last n copies. Use Powershell for fancy stuff, regular batch files for the basics. There are obvious security issues with this (scripts contain passwords etc) but this may not matter. Create a backup user with read-only access to minimise risk.
epo
How big is it? Could you just set up a Dropbox?
shothotbot
the people using this are not really fans of the command line They don't have to be, if you just can all the necessary command line worms in a small set of cmd scripts that they can just double-click to run (or schedule using the Task Scheduler). Make those robust and you should be fine.
flabdablet
Is http://aws.amazon.com/rds/ an option?
mkultra
http://ask.metafilter.com/212739/Hasslefree-backup-for-MySQL-under-Windows#3069239: "How big is it? Could you just set up a Dropbox?" You really shouldn't do something like that with MySQL. Unless you take special measures, the on-disk database may not be consistent at any given moment.
vasi
Related Q & A:
- Where can I download free windows vista themes?Best solution by Yahoo! Answers
- Is there a program similar to "Windows Movie Maker" that I could download for free?Best solution by Yahoo! Answers
- Best Free Antivirus for Windows 7?Best solution by Super User
- How can I activate yahoo mail free with windows mail?Best solution by Yahoo! Answers
- Free video editing software for windows?Best solution by wiki.answers.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.