Export/Import Database using MySQL Workbench

What?
This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database.

Why?
If you're confined to use this product then this is how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better.

How?
  1. So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis that you already setup a connection to your database under the SQL Development section. Export/Import happens under the Server Administration section:


  2. Let's create a Server Instance, I'm going to specify the Take Parameters from Existing Database Connection option (note that I have obscured my personal settings in the following screenshot):



  3. In this screen, I've opted for Do not use Remote Management as I only want to export/import my database:



  4. Connected! Now click on Data Export in the left hand panel:



  5. In the screen that appears, select your database, specify to export to a Self-Contained File and click on Start Export:





Importing
  1. Before importing a SQL file, check that nothing in it instructs it to use a specific database (otherwise you might overwrite your LIVE/production database). Click on the Data Import/Restore link in the left panel.



Credit where Credit is Due:


Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: The information on this website is provided without warranty and any content is merely the opinion of the author. Please try to test in development environments prior to adapting them to your production environments. The articles are written in good faith and, at the time of print, are working examples used in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

Related Articles

Joes Revolver Map

Accreditation

Badge - Certified Zoho Creator Associate
Badge - Certified Zoho Creator Associate

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin - Valid till 8 May 2022 3QnhmaBX7LQSRsC9hh6Je9rGQKEGNQNfPb
© 2021 Joel Lipman .com. All Rights Reserved.