Config_Export

format

sql/latex/excel/csv/xml/xls/htmlexcel/htmlword/ods/odt

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

compression

none/zip/gzip/bzip2

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

asfile

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

charset

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

onserver

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

onserver_overwrite

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

remember_file_template

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

file_template_table

$cfg['Export']['file_template_table'] = '@TABLE@';

For versions prior to 3.4:

$cfg['Export']['file_template_table'] = '__TABLE__';

file_template_database

$cfg['Export']['file_template_database'] = '@DATABASE@';

For versions prior to 3.4:

$cfg['Export']['file_template_database'] = '__DB__';

file_template_server

$cfg['Export']['file_template_server'] = '@SERVER@';

For versions prior to 3.4:

$cfg['Export']['file_template_server'] = '__SERVER__';

ODS

ods_columns

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

ods_null

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

ODT

odt_structure

$cfg['Export']['odt_structure'] = TRUE;

odt_data

$cfg['Export']['odt_data'] = TRUE;

odt_columns

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

odt_relation

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

odt_comments

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

odt_mime

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

odt_null

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

HTML-Excel

htmlexcel_columns

$cfg['Export']['htmlexcel_columns'] = FALSE;

htmlexcel_null

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

HTML-Word

htmlword_structure

$cfg['Export']['htmlword_structure'] = TRUE;

htmlword_data

$cfg['Export']['htmlword_data'] = TRUE;

htmlword_columns

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

htmlword_null

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

Texy

texytext_structure

$cfg['Export']['texytext_structure'] = TRUE;

texytext_data

$cfg['Export']['texytext_data'] = TRUE;

texytext_columns

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

texytext_null

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

XLS

xls_columns

$cfg['Export']['xls_columns'] = FALSE;

xls_null

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

CSV

csv_columns

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

csv_null

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

csv_separator

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

csv_enclosed

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

csv_escaped

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

csv_terminated

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

Excel

excel_columns

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

excel_null

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

excel_edition

win/mac

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

Latex

latex_structure

$cfg['Export']['latex_structure'] = TRUE;

latex_data

$cfg['Export']['latex_data'] = TRUE;

latex_columns

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

latex_relation

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

latex_comments

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

latex_mime

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

latex_null

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

latex_caption

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

latex_structure_caption

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

latex_structure_continued_caption

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

latex_data_caption

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

latex_data_continued_caption

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

latex_data_label

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

For versions prior to 3.4:

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

latex_structure_label

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

For versions prior to 3.4:

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

SQL

sql_structure

$cfg['Export']['sql_structure'] = TRUE;

sql_data

$cfg['Export']['sql_data'] = TRUE;

sql_compat

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

sql_disable_fk

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

sql_use_transaction

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

sql_drop_database

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

sql_drop_table

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

sql_if_not_exists

$cfg['Export']['sql_if_not_exists'] = FALSE;

sql_auto_increment

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

sql_backquotes

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

sql_dates

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

sql_relation

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

sql_columns

this is for defining the default state of the "Complete inserts" checkbox

$cfg['Export']['sql_columns'] = TRUE;

sql_delayed

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

sql_ignore

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

sql_hex_for_binary

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

sql_type

insert/update/replace

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

sql_extended

$cfg['Export']['sql_extended'] = TRUE;

sql_max_query_size

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

sql_comments

$cfg['Export']['sql_comments'] = FALSE;

sql_mime

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

sql_header_comment

\n is replaced by new line

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

PDF

pdf_structure

$cfg['Export']['pdf_structure'] = FALSE;

pdf_data

$cfg['Export']['pdf_data'] = TRUE;

pdf_report_title

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

Popular destinations:

User resources: