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.




4 comments: