Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2007-08-26 12:20:38
- carrotrope
- Member
- From: Edinburgh
- Registered: 2007-03-16
- Posts: 39
Settings for successful SQL dump
Hi all,
So I’m making the move to a MediaTemple (gs) account and I’m exporting a SQL dump from PHPMyAdmin – I just wanted to know what options should and shouldn’t be selected for a successful export and then import. I’m talking options like ‘Add DROP DATABASE’, ‘Extended Inserts’ etc – I’m fairly new to SQL and have no idea what most of these options imply.. what’s the best configuration for Textpattern?
Thanks,
Jez
Offline
Re: Settings for successful SQL dump
You don’t need ‘drop database’ or ‘extended inserts’.
When moving between hosts, it’s probably more important to know which MySQL versions are used on the old and new hosts, since that can cause charset issues when migrating.
Offline
#3 2007-08-26 17:02:41
- carrotrope
- Member
- From: Edinburgh
- Registered: 2007-03-16
- Posts: 39
Re: Settings for successful SQL dump
Ruud,
Thanks – both are 4.1 so hopefully there won’t be any issues there.
So currently, when exporting the SQL dump, these are the options I have selected:
Export (SQL)
Structure (Add AUTO_INCREMENT value) and (Enclose table and field names with backquotes)
Data (Complete inserts) and (Use hexadecimal for binary fields)
At least, these are the default selected options when I select ‘Export’ – Does this all seem to be in order?
Jez
Last edited by carrotrope (2007-08-26 17:04:16)
Offline
#4 2007-08-27 03:19:09
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Settings for successful SQL dump
Extended inserts import much, much faster in my experience. You’d have to work with large databases to notice it though (in which case you’d use mysqldump instead of phpMyAdmin).
Offline
Pages: 1