A full stack developer has the functional knowledge and the ability to work on all aspects involved in building an application. Also capable of performing tasks at any level of the technical stack in which they reside.
Thursday, April 19, 2018
How to import/export database in MySQL workbench
Open MySQL Workbench. To take database backup you have localhost or server.
Select instance on which you are working or on which your database present.
If you want to create server database click on plus '+' symbol to create a server as shown in the following screenshot.
How to Export Database
Click on management tab on the left side navigation panel.
Click on 'Data Export'.
Select schema/database which you want to export or take backup. then click on 'start export'. As shown in the following screenshot.
Before import database, you should have schema or database with that name which you are importing. If you don't have that schema then create the schema as shown in the following screenshot.
Click on management tab on the left side navigation panel.
Click on 'Data Import'
Select database dumb folder to import.
Click on 'Start Import'. As shown in following screenshot.
Thank you for posting the valuable information.
ReplyDeleteFull Stack Online Training
Nice blog, very interesting to read
ReplyDeleteI have bookmarked this article page as i received good information from this.
Full Stack Online Training
This comment has been removed by the author.
ReplyDeleteValuable post useful for everyone.Keep on sharing.
ReplyDeleteFull Stack Online Training
Full Stack Training
Full Stack Developer Online Training
full stack training in hyderabad
Full Stack Training in Ameerpet