Keeping a back up of your database is one of the most important tasks you should be performing, the utmost care should be taken to ensure you have an up-to-date backup. It’s very easy to use and using this we can take backup and restore web projects database.
MySQL Workbench provides DBAs and developers an integrated tools environment for:
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.
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’
Prem Tiwari is the founder of FreeWebMentor.com and also a professional developer who has vast experience in PHP and open source technologies. Apart from this, he is a blogger by hobby and also he has been a regular speaker of WordPress sessions in various IT Companies. View all posts by Prem Tiwari