|
Contents
Index
<< Previous
Next >>
PDF
SQL File
|
|
Menu: File / Export / SQL File
The selected data and their structures are exported to a SQL file. This conforms largely to the output of mysqldump.
Use this file to save the content of database to a file. This is rather practical for data backup or to send data, for example.
Include:
| Structure: Exports the data structure with CREATE TABLE queries.
|
Database:
| Create Database(s): Generates CREATE DATABASE queries
|
| Select Database(s): Generates USE `databasename` queries
|
Handle existing data:
| Drop before Create: Generates a corresponding DROP query before each CREATE query to delete any existing data.
|
| Complete Insert Queries: Generates INSERT queries for which the field name is also indicated for every field. (Only meaningful if data are not to be added to an existing table and if the existing table does not exactly correspond with the table to be exported.)
|
General:
| Include Comments: Adds comments to the file to make the file easier to read.
|
| Disable Keys: Deactivates foreign key verification while importing the file.
|
| Lock Tables: Prevents updates of other programs/users during the export.
|
Note:
| Unfortunately the exported SQL file has no unlimited backward compatibility. This problem is present since a lot of different MySQL database versions, compilations and configurations does not allow to generate one SQL file which runs well on each different MySQL server.
|
| To transfer data to a lower versioned MySQL server please use the Transfer feature of MySQL-Front.
|
|
|
