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 columns 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:  | 
      
