[Phpmyadmin-devel] "Quick Export/Import"

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 - 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 - 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 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 -- Thanks, Lori

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
participants (2)
-
Lori Lee
-
Marc Delisle