6.5 Data Export and Import
There are three ways to export and import data in MySQL Workbench, each serving a different purpose.
Table 6.1 Methods to Export or Import data in MySQL Workbench
| GUI Location | Data Set | Export Types | Import Types | Additional Details |
|---|---|---|---|---|
| Object Browser context menu | Tables | JSON, CSV | JSON, CSV | Simple table operations, includes moderate control over the output type (this method was added in version 6.3.0). |
| Result Grid menu under the SQL editor | Result set (after performing an SQL query) | CSV, HTML, JSON, SQL, XML, Excel XML, TXT | CSV | Simple data operations, includes little control. |
| Management Navigator | Databases and/or Tables | SQL | SQL | Detailed database and table operations, standard backup/restore behavior using the mysqldump command and meta data, includes control over how data is handled, and includes meta data. |
| Management Navigator | Databases and/or Tables | SQL | SQL | Detailed database and table operations, includes control over how data is handled, can be scheduled and incremental, includes meta data, uses MySQL Enterprise Backup (commercial). |
© 2025 Oracle
Licensed under the GPLv2 License.
