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
- Open the Data or Results tab, press Export Data on one of the Data View toolbars.
- Open the Data or Results tab, choose Data Manipulation | Export Data in the Data Grid context menu.
- Open the table context menu in the DB Explorer, choose the Data Manipulation | Export Data item.
- 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
- Open the Data tab, press the Import Data button on one of the Data View toolbar.
- Open the Data tab, choose Data Manipulation | Import Data in the Data Grid context menu.
- Open the table context menu in the DB Explorer, choose the Import Data item.
- 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.