Export

$cfg['Export']['format'] = 'sql';

$cfg['Export']['method'] = 'quick';

$cfg['Export']['compression'] = 'none';

Whether to LOCK TABLES before exporting

Whether to export databases/tables as separate files

$cfg['Export']['asfile'] = true;

$cfg['Export']['charset'] = '';

$cfg['Export']['onserver'] = false;

$cfg['Export']['onserver_overwrite'] = false;

$cfg['Export']['quick_export_onserver'] = false;

$cfg['Export']['quick_export_onserver_overwrite'] = false;

$cfg['Export']['remember_file_template'] = true;

Default filename template for table exports.

Default filename template for database exports.

Default filename template for server exports.

$cfg['Export']['codegen_structure_or_data'] = 'data';

$cfg['Export']['codegen_format'] = 0;

$cfg['Export']['ods_columns'] = false;

$cfg['Export']['ods_null'] = 'NULL';

$cfg['Export']['odt_structure_or_data'] = 'structure_and_data';

$cfg['Export']['odt_columns'] = true;

$cfg['Export']['odt_relation'] = true;

$cfg['Export']['odt_comments'] = true;

$cfg['Export']['odt_mime'] = true;

$cfg['Export']['odt_null'] = 'NULL';

$cfg['Export']['htmlword_structure_or_data'] = 'structure_and_data';

$cfg['Export']['htmlword_columns'] = false;

$cfg['Export']['htmlword_null'] = 'NULL';

$cfg['Export']['texytext_structure_or_data'] = 'structure_and_data';

$cfg['Export']['texytext_columns'] = false;

$cfg['Export']['texytext_null'] = 'NULL';

$cfg['Export']['csv_columns'] = true;

$cfg['Export']['csv_structure_or_data'] = 'data';

$cfg['Export']['csv_null'] = 'NULL';

$cfg['Export']['csv_separator'] = ',';

$cfg['Export']['csv_enclosed'] = '"';

$cfg['Export']['csv_escaped'] = '"';

$cfg['Export']['csv_terminated'] = 'AUTO';

$cfg['Export']['csv_removeCRLF'] = false;

$cfg['Export']['excel_columns'] = true;

$cfg['Export']['excel_null'] = 'NULL';

$cfg['Export']['excel_edition'] = 'win';

$cfg['Export']['excel_removeCRLF'] = false;

$cfg['Export']['excel_structure_or_data'] = 'data';

$cfg['Export']['latex_structure_or_data'] = 'structure_and_data';

$cfg['Export']['latex_columns'] = true;

$cfg['Export']['latex_relation'] = true;

$cfg['Export']['latex_comments'] = true;

$cfg['Export']['latex_mime'] = true;

$cfg['Export']['latex_null'] = '\textit{NULL}';

$cfg['Export']['latex_caption'] = true;

$cfg['Export']['latex_structure_caption'] = 'strLatexStructure';

$cfg['Export']['latex_structure_continued_caption'] = 'strLatexStructure strLatexContinued';

$cfg['Export']['latex_data_caption'] = 'strLatexContent';

$cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';

$cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data';

$cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure';

$cfg['Export']['mediawiki_structure_or_data'] = 'data';

$cfg['Export']['mediawiki_caption'] = true;

$cfg['Export']['mediawiki_headers'] = true;

$cfg['Export']['ods_structure_or_data'] = 'data';

$cfg['Export']['pdf_structure_or_data'] = 'data';

$cfg['Export']['phparray_structure_or_data'] = 'data';

$cfg['Export']['json_structure_or_data'] = 'data';

$cfg['Export']['json_pretty_print'] = false;

$cfg['Export']['json_unicode'] = true;

$cfg['Export']['sql_structure_or_data'] = 'structure_and_data';

$cfg['Export']['sql_compatibility'] = 'NONE';

Whether to include comments in SQL export.

$cfg['Export']['sql_disable_fk'] = false;

$cfg['Export']['sql_views_as_tables'] = false;

$cfg['Export']['sql_metadata'] = false;

$cfg['Export']['sql_use_transaction'] = true;

$cfg['Export']['sql_create_database'] = false;

$cfg['Export']['sql_drop_database'] = false;

$cfg['Export']['sql_drop_table'] = false;

true by default for correct behavior when dealing with exporting of VIEWs and the stand-in table

$cfg['Export']['sql_view_current_user'] = false;

$cfg['Export']['sql_or_replace_view'] = false;

$cfg['Export']['sql_procedure_function'] = true;

$cfg['Export']['sql_create_table'] = true;

$cfg['Export']['sql_create_view'] = true;

$cfg['Export']['sql_create_trigger'] = true;

$cfg['Export']['sql_auto_increment'] = true;

$cfg['Export']['sql_backquotes'] = true;

$cfg['Export']['sql_dates'] = false;

$cfg['Export']['sql_relation'] = false;

$cfg['Export']['sql_truncate'] = false;

$cfg['Export']['sql_delayed'] = false;

$cfg['Export']['sql_ignore'] = false;

Export time in UTC.

$cfg['Export']['sql_hex_for_binary'] = true;

$cfg['Export']['sql_type'] = 'INSERT';

$cfg['Export']['sql_max_query_size'] = 50000;

$cfg['Export']['sql_mime'] = false;

\n is replaced by new line

Whether to use complete inserts, extended inserts, both, or neither

$cfg['Export']['pdf_report_title'] = '';

$cfg['Export']['xml_structure_or_data'] = 'data';

Export schema for each structure

Export events

Export functions

Export procedures

Export schema for each table

Export triggers

Export views

Export contents data

$cfg['Export']['yaml_structure_or_data'] = 'data';

$cfg['Export']['remove_definer_from_definitions'] = false;