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?

RolandoMySQLDBA
  • 182,700
  • 33
  • 317
  • 520
Sagotharan
  • 111
  • 5
  • 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 09: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 04 '15 at 17:24

3 Answers3

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:

  • 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. –  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. –  Jan 31 '12 at 11:19
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.

Community
  • 1
RolandoMySQLDBA
  • 182,700
  • 33
  • 317
  • 520
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.

Remus Rusanu
  • 51,846
  • 4
  • 95
  • 172