What settings to use for Export database phpMyAdmin?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
MarcB
Registered User
Posts: 138
Joined: Sun Jun 14, 2009 2:48 pm
Location: Netherlands
Contact:

What settings to use for Export database phpMyAdmin?

Post 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?

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51931
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: What settings to use for Export database phpMyAdmin?

Post by Brf »

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

User avatar
AdamR
Former Team Member
Posts: 9731
Joined: Tue Mar 02, 2004 5:40 pm
Location: Tampa, Florida
Name: Adam Reyher
Contact:

Re: What settings to use for Export database phpMyAdmin?

Post 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
phpBB Support: Welcome | Userguide | Knowledge Base | Search
Honored supporter of the phpBB Group!
"If I have seen a little further it is by standing on the shoulders of Giants." - Isaac Newton

User avatar
MarcB
Registered User
Posts: 138
Joined: Sun Jun 14, 2009 2:48 pm
Location: Netherlands
Contact:

Re: What settings to use for Export database phpMyAdmin?

Post 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?

ember1
Registered User
Posts: 20
Joined: Fri Aug 21, 2009 2:51 am

Re: What settings to use for Export database phpMyAdmin?

Post 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

Locked

Return to “[3.0.x] Support Forum”