Database Reference
In-Depth Information
SQL options
SQL options are used to define exactly what information the export will contain. We
may want to see the structure, the data, or both. Selecting
Structure
generates the
section with
CREATE
queries, and selecting
Data
produces
INSERT
queries:
The general SQL options are:
•
Add custom comment into header
: We can add our own comments for
this export (for example,
Monthly backup
), which will show in the export
headers (after the PHP version number). If the comment has more than one
line, we must use the special character
\n
to separate each line.
Comments
•
: Removing the check mark here causes the export to have no
comments at all.
Enclose export in a transaction
•
: Starting with MySQL 4.0.11, we can use
the
START
TRANSACTION
statement. This command, combined with
SET
AUTOCOMMIT=0
at the beginning and
COMMIT
at the end, asks MySQL to
execute the import (when we will re-import this file) in one transaction,
ensuring that all the changes are done as a whole.
Search WWH ::
Custom Search