Online Documentation for SQL Manager for MySQL

Export/import data


You can export data from a database table into an external file of any supported format by means of the Export Data Wizard.

 

There are several ways to launch Export Data Wizard

  1. Open the Data or Results tab, press iconTools_ExportData Export Data on one of the Data View toolbars.
  2. Open the Data or Results tab, choose Data Manipulation | iconTools_ExportData Export Data in the Data Grid context menu.
  3. Open the table context menu in the DB Explorer, choose the Data Manipulation | iconTools_ExportData Export Data item.
  4. Open the Data or Results tab and use the shortcut Shift+Ctrl+E.

 

You can import data from external sources into a table or view using Import Data Wizard

  1. Open the Data tab, press the iconTools_ImportData Import Data button on one of the Data View toolbar.
  2. Open the Data tab, choose Data Manipulation | iconTools_ImportData Import Data in the Data Grid context menu.
  3. Open the table context menu in the DB Explorer, choose the iconTools_ImportData Import Data item.
  4. Open the Data tab and use the shortcut Ctrl+I.

 

Note: Export and import data tolls are available in full version of SQL Manager for MySQL only.