MySQL Workbench Manual  /  Administrative Tasks  /  Data Export and Import

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).