Some days back I had posted an article about MySQL WorkBench Usage. So in this post I want to explain how to take backup your database using MySQL Administrator. It's a part of MySQL GUI Tools.
It's very easy to use and using this we can take backup and restore web projects database.
Download MySQL AdministratorStep - 1
You have to select backup button and click new project button.
Step - 2
It's display project database tables, you have to select particular project database and dump to back content.
Restore Database
Using this tool we can restore data also just click open backup file button and you have to give the .sql file URL. Click 'Start Restore'
Related Post
Visual Database Design with MySQL Workbench
The link to download MySQL Administrator is broken. It should point to http://dev.mysql.com/downloads/gui-tools/5.0.html
ReplyDeleteThanks Martey, now download link working
ReplyDeletecan i take backup of database which is currently being used. Eg ABC is my database in My SQL Control Center and is being used by my website. The data is being inserted and modified in database continuously.
ReplyDeleteIf i take backup while my website is still accessing db ABC will it affect any way, do i have to take some precautions OR i should just go ahead and follow the steps mentioned in ur URL. Reply ASAP plzz
No problem.. go ahead.
ReplyDeletethanks a lot .. its a wonderful article ..i think concepts are much clear when screenshots/videos are there ..
ReplyDeleteis there anyway i can automate this process.
ReplyDeletei have to take backups everyday by end of the day ..
how can i take backup of the stored procedures along with tables
ReplyDeleteHow do I archive my database? Is the procedure as same as backup a database?
ReplyDeleteGuru Extrordinory Thing,,,,,,,Very Nice
ReplyDelete