This wizard supports import and export operations using CSV and JSON files, and includes several configuration options (separators, column selection, encoding selection, and more). The wizard can be performed against local or remotely connected MySQL servers, and the import action includes table, column, and type mapping.
This wizard only exports/imports tables using the JSON or CSV format. For an overview of the data export and import options in MySQL Workbench, see Section 6.5, “Data Export and Import”.
The wizard is accessible from the object browser's context menu by right-clicking on a table and choose eitheror , as the next figure shows.
Export table data to either a JSON or CSV file. The following figures show an example of an export sequence of the sakila.actor table to a CSV file.
You can import table data from either a JSON or CSV file. The following figures show an example of an import sequence of the sakila.actor table from a CSV file.
The Encoding field should correspond with your CSV file.