Online Documentation for SQL Manager for MySQL
Save Data Wizard
Save Data Wizard allows you to use the SELECT ... INTO OUTFILE MySQL statement to get a dump of a table at a very high speed. The file must be accessible to the server and the name must be specified from the viewpoint of the server. You can save your settings as a template any time for future use.
To start the wizard, right-click the table in DB Explorer, select the Data Manipulation | Save Data to File on Server... context menu item.
Alternatively, you can open the Data tab of Table Editor / View Editor or the Result(s) tab of SQL Editor / Query Builder, right-click the grid there, then select the Data Manipulation | Save Data to File on Server... context menu item.
- Setting destination file name
- Selecting fields for saving data
- Specifying data format parameters
- Saving data
Availability: |
|
Full version (for Windows) |
Yes |
Lite version (for Windows) |
No |
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
See also: |