How do i import and export data from mysql workbench?

On this page:

• Overview
• MySQL restoration policy
• Manually back up your MySQL for IU Sitehosting schemas
  • Create a backup using MySQL Workbench
  • Load a MySQL dump from MySQL Workbench

Overview

MySQL for IU Sitehosting uses the MySQL Enterprise Backup features on a nightly schedule. These backups are retained for 14 days for service-wide disaster recovery purposes.

MySQL restoration policy

If you need to back up or restore your data for any purpose (development, transference from production to test, etc.), you should take advantage of the functionality and tools that MySQL Workbench offers (for example, mysqldump or Data Export and Import Wizard).

The Database Administration team will perform MySQL data restoration in extremely limited cases, such as data loss due to SQL injection or unforeseen corruption. Data restoration services are performed on a case-by-case basis and are subject to review and approval by administrators. In all cases, data restoration is limited to the previous night's updates. Binary logs are not active, and it is not possible to provide point-in-time recovery. Data restoration may take up to 48 business hours to process.

To request data restoration, email Tier 2 Support. Include the date and time the incident requiring data recovery occurred and the type of incident that spurred your request. You may be asked to provide information about what steps you have taken to mitigate the need for future data restoration. Staff will forward your request to the Database Administration team, who will contact you with options or further questions they may have.

Departments and owners of sites who require 24x7 data backup and restoration services are encouraged to contact the Database Administration team to discuss options, which may include creating an Enterprise MySQL instance for just that site's content and on-call data recovery services. A fee may be associated with these services.

Manually back up your MySQL for IU Sitehosting schemas

Create a backup using MySQL Workbench

Note:

Store this backup file in a manner consistent with the data classification appropriate to your site's content. Sites which store sensitive internal or critical data must be stored in secure locations.

If you're using versions of Workbench before 6.3.8, including on IUanyWare, you will have an unhandled exception when trying to export on the new system. You will be unable to export until you update Workbench.

1. Connect to your MySQL database.
2. Click on the main tool bar.
3. Select .
4. Select the tables you want to back up.
5. Under , select where you want your dump saved. By default, it will save to your Documents folder in a subfolder titled dumps.
6. Click .

   Note:

   You may get a message about a mismatch between your mysqldump.exe version and the MySQL Server version. You can update your local MySQL version or continue.

7. You now have a backup version of your site. Store this content securely in a manner consistent with your MySQL schema content's data classification.

Load a MySQL dump from MySQL Workbench

To load a MySQL dump file after a database failure or corruption:

1. Connect to your MySQL database.
2. Click on the main tool bar.
3. Select .
4. You should see a link to the default dump folder, typically your Documents folder in a subfolder titled dumps.
5. Click the and navigate to where your MySQL backup file is located, select the backup you want to load, and click .
6. The schema names in your dump should appear on the left-hand side, at the bottom. Select the schemas that need to be restored.
7. Select on the bottom right.

This is document apnn in the Knowledge Base.
Last modified on 2021-09-21 15:49:27.

I created a database in mysql. I have a .sql file. how can i import it into my database via mysql workbench ?

asked Apr 8, 2013 at 16:52

2

• Under Server Administration on the Home window select the server instance you want to restore database to (Create New Server Instance if doing it first time).
• Click on Manage Import/Export
• Click on Data Import/Restore on the left side of the screen.
• Select Import from Self-Contained File radio button (right side of screen)
• Select the path of .sql
• Click Start Import button at the right bottom corner of window.

Hope it helps.

---Edited answer---

Regarding selection of the schema. MySQL Workbench (5.2.47 CE Rev1039) does not yet support exporting to the user defined schema. It will create only the schema for which you exported the .sql... In 5.2.47 we see "New" target schema. But it does not work. I use MySQL Administrator (the old pre-Oracle MySQL Admin beauty) for my work for backup/restore. You can still download it from Googled trustable sources (search MySQL Administrator 1.2.17).

answered Apr 8, 2013 at 17:34

VishyVishy

1,26212 silver badges17 bronze badges

9

For MySQL Workbench 6.1: in the home window click on the server instance(connection)/ or create a new one. In the thus opened 'connection' tab click on 'server' -> 'data import'. The rest of the steps remain as in Vishy's answer.

answered Aug 8, 2014 at 14:26

aunindoaunindo

1332 silver badges9 bronze badges

1. Open Connetion
2. Select "Administration" tab
3. Click on Data import

Upload sql file

Make sure to select your database in this award winning GUI:

answered Jan 7, 2021 at 12:58

AdamAdam

22.5k20 gold badges133 silver badges216 bronze badges

1

For MySQL Workbench 8.0 navigate to:

A new tab called Administration - Data Import/Restore appears. There you can choose to import a Dump Project Folder or use a specific SQL file according to your needs. Then you must select a schema where the data will be imported to, or you have to click the New... button to type a name for the new schema.

Then you can select the database objects to be imported or just click the Start Import button in the lower right part of the tab area.

Having done that and if the import was successful, you'll need to update the Schema Navigator by clicking the arrow circle icon.

That's it!

For more detailed info, check the MySQL Workbench Manual: 6.5.2 SQL Data Export and Import Wizard

answered Jun 19, 2020 at 18:54

MetafanielMetafaniel

27.5k7 gold badges38 silver badges61 bronze badges

How do I export and import data from MySQL workbench?

How do I export data from MySQL workbench?

How do I extract data from a workbench?

How do I import data from MySQL workbench to CSV?