Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

need backup MySQL 5.1 databse. Database is install on Windows Server 2003. I google it and I found many tools but I am little confuse what choose.

My requirments are:

  • Tool for backup must have a GUI
  • It would be good if support only backup, without shutdown database
  • It must run under windows
  • I would like only choose MySQL folder source and destination folder for backup, second setup time when start backup. For example once time at week.
  • option for restore data from backup

Do you have good suggestion for me?

share|improve this question
add comment

1 Answer

Backups of MySQL are normally done via the command line but if you really want a GUI interface you could use something like HeidiSQL, which allows you to export and import your data as eithe CSV or SQL files, which you can place wherever you like.

I do recommend that you learn to use the command line tools, such as mysqldump as that will allow you to automate these things, which is how backups should be run.

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.