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:<br><br>General options:<br>=======================<br>- databases/tables: select all<br>- output: save as file<br> - save on server: true<br>
- overwrite existing file(s): user must choose<br> - file name template: whatever value is already there<br> - remember template: true<br> - character set of the file: whatever the default is<br> - compression: none<br>
<br>SQL options:<br>========================<br>- display comments: true<br> - additional custom header comment: blank<br> - creation/Update/Check dates: true<br> - relations: true<br> - MIME type: true <br>
<br>- enclose export in a transaction: false<br>- disable foreign key checks: false<br>- maximize compatibility with: whatever the default is<br>- add DROP DATABASE statement: false<br>- dump: structure and data<br> <br>
Structure options:<br>- Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT: false<br>- Add IF NOT EXISTS: true<br>- Add AUTO_INCREMENT value: true<br>- Enclose table and field names with backquotes: true<br>- Add CREATE PROCEDURE / FUNCTION / EVENT: false<br>
<br>Data options:<br>- delayed inserts: false<br>- ignore inserts: false<br>- complete and/or extended inserts: both<br>- Use hexadecimal for BLOB: true<br>- Export time in UTC: true<br>- Maximal length of created query: whatever the default is<br>
- Export type: INSERT<br><br> <br>-- <br>Thanks,<br>Lori<br>