Important Notice:
Two sections of this forum are available only to registered customers. In order to receive access to the Customer Forums and ResellerCentral Forums, you must first register on these forums or login to your existing forum account. If you are an existing HostNine customer, be sure to register using the email address on file for your billing profile.
|
|||||||
![]() |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
When exporting a database, what are the usual settings we should be using
These are the h9 defaults, should I match those on local ? Add IF NOT EXISTS Add AUTO_INCREMENT value Enclose table and field names with backquotes Complete inserts Extended inserts Use hexadecimal for BLOB |
|
#2
|
|||
|
|||
|
The export setting depend entirely on what you want to do with the data after it is exported. The default settings are good for your everyday exports.
I do like to add Insert Ignore to the options when exporting data in addition to structure. |
![]() |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Question | Dadss | Reseller Hosting | 1 | 05-11-2008 08:35 PM |
| SSH IP question | mrathell | Web Hosting | 16 | 04-23-2008 11:49 PM |
| Few issues: phpmyadmin and disk space low | hostmaxpro | Reseller Hosting | 2 | 04-07-2008 03:13 AM |
| phpMyAdmin | jleemc44 | Reseller Hosting | 14 | 07-27-2007 06:35 AM |







Linear Mode

