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
Thanks Martey, now download link working
can 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.
If 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.
thanks a lot .. its a wonderful article ..i think concepts are much clear when screenshots/videos are there ..
is there anyway i can automate this process.
i have to take backups everyday by end of the day ..
how can i take backup of the stored procedures along with tables
How do I archive my database? Is the procedure as same as backup a database?
Guru Extrordinory Thing,,,,,,,Very Nice