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 Administrator
Step - 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.
Finally click execute backup database button. It's will generate .sql file.
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'
Visual Database Design with MySQL Workbench
Thanks! Your feedback helps us to improve 9lessons.info