[Phpmyadmin-devel] "Quick Export/Import"

Lori Lee leelorik at gmail.com
Thu May 27 01:04:00 CEST 2010


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20100526/c58e09da/attachment.html>


More information about the Developers mailing list