1

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?

  • 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 Sep 4 '15 at 17:24
1

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:

| 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
0

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.

| improve this answer | |
0

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.

| improve this answer | |

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