[Phpmyadmin-devel] "Quick Export/Import"

[Marc Delisle]

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