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 using VS2010 and MySQL for my project. My client wantw to take mysqldump every day like a daily backup. I want to give my client a tool for taking mysqldumps on a particular time schedule.

Do you know any tool that can fulfill my requirement?

share|improve this question

put on hold as off-topic by Colin 't Hart, Phil, Mark Sinkinson, Vérace, Mark Storey-Smith 31 mins ago

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." – Colin 't Hart, Phil, Mark Sinkinson, Vérace, Mark Storey-Smith
If this question can be reworded to fit the rules in the help center, please edit the question.

2  
Several, but it depends on MySQL edition, Engine used, OS+filesystem, 3rd party plugins or extensions (eg XtraDB). So, can you add more detail please to help us to help you... –  gbn Jan 31 '12 at 9:15
    
Your question is too broad - and a "shopping list". Google "windows mysql automatic backup" or similar - then come back to us with particular questions. Voting to close. –  Vérace 1 hour ago

3 Answers 3

I assume you are using Windows (because of you mention VS2010).

Simply create a "scheduled job" either through the Windows UI (e.g. start control schedtasks) or the at command. This taks should run mysqldump at the desired time.

Here are some links that explain how to create a scheduled task in Windows:

http://technet.microsoft.com/en-us/library/cc758861%28WS.10%29.aspx
http://serverfault.com/questions/51524/list-add-edit-delete-windows-scheduled-tasks-from-the-command-line
http://support.microsoft.com/kb/814596
http://support.microsoft.com/kb/308569

share|improve this answer
    
I assumed a remote MySQL instance, not local. Especially when it goes live. –  gbn Jan 31 '12 at 10:40
    
@gbn: you can schedule jobs on a remote system as well. –  a_horse_with_no_name Jan 31 '12 at 10:44
    
If the remote server is Solaris using ZFS with Community edition, you'd need to use a ZFS snapshot with MySQL stopped via crontab or such... –  gbn Jan 31 '12 at 10:46
    
@gbn: you could still schedule a mysqldump using cron. –  a_horse_with_no_name Jan 31 '12 at 11:19

Usually you deploy an existing maintenance script which takes care not only of taking the dump (trivial), but also of deleting the old backup files, naming them accordingly, handling various possible failures etc etc. Eg. I use backup-manager and I'm quite pleased with it.

share|improve this answer

I have a 1.5-year-old post (mysqldump with automatically generated export name) on how to create mysqldump backups in a Windows environment using DOS Batch Programming.

You can create a Task Scheduler job that launches the batch file on some timeframe.

EPILOGUE

Looking for 3rd tools is not worth time, effort, or the money if it can be scripted.

share|improve this answer

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