:: DEVELOPER ZONE
MySQL Administrator :: 12.3.2 Output File Options
The Output File Options control the formatting
of the backup file. At present there is only one Backup
Type available, the SQL Files format,
which outputs a file similar to the output of the
mysqldump utility.
No CREATEs will supress CREATE
DATABASE statements. This can be useful if you need to
restore the data to a different database than it was backed up
from.
No EXTENDED INSERTS will supress the default
behavior of combining multiple inserts into a single statement (for
example INSERT INTO test VALUES ('1',Some
data',2234),('2','Some More Data',23444)). While the
EXTENDED INSERT syntax is more efficient both in
terms of storage and execution, it is not compatible with most
RDBMSes.
Complete INSERTs will produce full
INSERT statements that include a column list
(i.e. INSERT INTO tablename(columnA, columnB)
VALUES(valueA, valueB)). Without this option the column
list will be omitted.
Comment
Don't write full path
ANSI Quotes will cause all table and database
names to be quoted with ANSI style double quotes instead of
back-ticks.
Disable keys will add an ALTER TABLE
... DISABLE KEYS statement to the backup file before the
INSERT statements that populate the tables. This
allows for faster recovery by loading all data before rebuilding
the index information.
© 1995-2005 MySQL AB. All rights reserved.
