MySQL workbench - table data import and export procedure

This is a redistribution of import and export features of MySQL workbench.

6.5.1 Table Data Export and Import Wizard

https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html

he wizard is accessible from the object browser's context menu by right-clicking on a table and choose either Table Data Export Wizard orTable Data Import Wizard.

Figure 6.14 Table Data Wizards: Open

Table Data Export Wizard

Export table data to either a JSON or CSV file. The following example exports the sakila.actor table to a CSV file.

Figure 6.15 Table Data Export: Source

Figure 6.16 Table Data Export: CSV Configuration

Figure 6.17 Table Data Export: Results

Table Data Import Wizard

Import table data from either a JSON or CSV file. The following example imports the sakila.actor table from a CSV file.

Figure 6.18 Table Data Import: CSV Source

Figure 6.19 Table Data Import: Destination Table

Figure 6.20 Table Data Import: CSV Configuration

Note

The Encoding field should correspond with your CSV file.

Figure 6.21 Table Data Import: Results