MySQL Workbench

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 LocationData SetExport TypesImport TypesAdditional Details
Object Browser context menuTablesJSON, CSVJSON, CSVSimple table operations, includes moderate control over the output type (this method was added in version 6.3.0)
Result Grid menu under the SQL editorResult set (after performing an SQL query)CSV, HTML, JSON, SQL, XML, Excel XML, TXTCSVSimple data operations, includes little control
Management NavigatorDatabases and/or TablesSQLSQLDetailed 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 NavigatorDatabases and/or TablesSQLSQLDetailed database and table operations, includes control over how data is handled, can be scheduled and incremental, includes meta data, uses MySQL Enterprise Backup (commercial)