Page 1 of 1

What settings to use for Export database phpMyAdmin?

Posted: Sat Dec 26, 2009 11:33 am
by 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?

Re: What settings to use for Export database phpMyAdmin?

Posted: Sat Dec 26, 2009 1:55 pm
by Brf
That article tells you what settings to use.
Anything it does not mention, you should leave at the default value.

Re: What settings to use for Export database phpMyAdmin?

Posted: Sun Dec 27, 2009 5:02 am
by 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

Re: What settings to use for Export database phpMyAdmin?

Posted: Sun Dec 27, 2009 9:17 am
by 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?

Re: What settings to use for Export database phpMyAdmin?

Posted: Sun Feb 21, 2010 11:46 pm
by 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!

Image