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?
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 only takes a minute to sign up.Sign up to join this community
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:
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.
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.
Looking for 3rd tools is not worth time, effort, or the money if it can be scripted.