What are the ways of Data Import and Export in MySQL Workbench

Question

Hi!

Can someone tell me what are the ways of Data Export and Import in MySQL Workbench?

Answer 1

There are majorly three ways to export and import data:

Gui Location	Data Set	Export Types	Import Types
Result Grid menu under the SQL editor	The result set (after performing an SQL query)	CSV, HTML, JSON, SQL, XML, Excel XML, TXT	CSV
Object Browser context menu	Tables	JSON, CSV	JSON, CSV
Management Navigator	Databases and/or Tables	SQL	SQL