What settings to use for Export database phpMyAdmin?

[MarcB]

I was searching for documentation on exporting the database by means of phpMyAdmin in combination with the usage of BigDump.php. I found following article in the Knowledge base section which is great Transferring Your Board to a New Host or Domain

However, I need some support as I am still missing some information regarding the export settings when using phpMyAdmin. I have marked the missing information with a

I am using phpMyAdmin 2.9.1.1-Debian-11 / MySQL client version: 5.0.84


Export section
“Select All” and tick radio button “SQL” Knowledge Base Article

SQL options section
Add custom comment into header (\n splits lines) -> leave open?
Enclose export in a transaction -> tick/untick checkbox?
Disable foreign key checks-> tick/untick checkbox?
SQL compatibility mode -> What setting?

Structure section
Structure -> tick
Add DROP TABLE / DROP VIEW -> tick Knowledge Base Article
Add IF NOT EXISTS-> tick/untick checkbox?
Add AUTO_INCREMENT value -> tick/untick checkbox?
Enclose table and field names with backquotes -> tick/untick checkbox?

Add into comments section
Creation/Update/Check dates -> tick/untick checkbox?

Data section
Data -> tick Knowledge Base Article
Complete inserts -> tick Knowledge Base Article
Extended inserts - untick Knowledge Base Article
Maximal length of created query -> what value?
Use delayed inserts -> tick/untick checkbox?
Use ignore inserts -> tick/untick checkbox?
Use hexadecimal for binary fields -> tick/untick checkbox?
Export type -> INSERT

Save as file section
Save as file -> tick
File name template -> _DB_ Knowledge Base Article
Compression -> What setting?

[Brf]

That article tells you what settings to use.
Anything it does not mention, you should leave at the default value.

[AdamR]

Indeed, any option not directly mentioned in the article should be left at its default value.

I have updated the article to add this clarification.

- Adam

[MarcB]

Thanks for the info!

I would like to understand the mechanism and therefore need to understand the effect of the different variables. The book "Mastering phpMyAdmin 3.1 for Effective MySQL Management" gives some detailed information but is still limited. Do you know any other detailed reference material?

[ember1]

I have read the threads, and studied the kb article; but I'd like some reassurance or correction. Am I setting up phpMyAdmin for a proper export of the database? See screenshot below. Thanks!