Lori Lee a écrit :
Regarding the new Export design, Marc noted that some
users might want
to “just do a backup” where all options that can be hidden, are hidden.
The backup would contain all possible features for structure and data.
Would these settings be okay:
General options:
=======================
- databases/tables: select all
- output: save as file
- save on server: true
Maybe these users would like to have the choice of the saving place,
each time.
- overwrite existing file(s): user must choose
- file name template: whatever value is already there
- remember template: true
- character set of the file: whatever the default is
- compression: none
SQL options:
========================
- display comments: true
- additional custom header comment: blank
You could add here something that denotes that a "quick backup" mode was
used.
- creation/Update/Check dates: true
- relations: true
- MIME type: true
- enclose export in a transaction: false
- disable foreign key checks: false
- maximize compatibility with: whatever the default is
- add DROP DATABASE statement: false
- dump: structure and data
Structure options:
- Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT: false
- Add IF NOT EXISTS: true
- Add AUTO_INCREMENT value: true
- Enclose table and field names with backquotes: true
- Add CREATE PROCEDURE / FUNCTION / EVENT: false
I suggest to set this one to "true" to avoid losing these. Hmmm, now I
wonder why this one is set to false by default.
Data options:
- delayed inserts: false
- ignore inserts: false
- complete and/or extended inserts: both
- Use hexadecimal for BLOB: true
- Export time in UTC: true
- Maximal length of created query: whatever the default is
- Export type: INSERT
The rest looks ok to me.
--
Marc Delisle
http://infomarc.info