MySQL Workbench Release Notes
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).|