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 want to take MySQL Dump Every Day like Daily Backup. So I want to give a tool for Taking MySQL Dump with a particular time.

Do you know any tool fulfill my requirement?

share|improve this 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
add comment

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
add comment

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
add comment

SQLyog has scheduled backup feature using this you can take periodic backup on certain time interval also there is an option to zip file added advantage is it has got notification if backup fails you will get notification along with failure cause as well.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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