|
Pages: [1] |  |
|
|
Author
|
Topic: moving host, different MySQL version? (Read 1074 times)
|
 Joined: Mar 2008 Posts: 45
 
 United States
|
Mar 21, 2008, 12:09:41 AM | #1 |
I currently have a site with a MySQL 5 database and version 2.9 of phpmyadmin We want to change the host, but the new host is running MySQL 4 and has phpmyadmin 2.6
Am I going to be able to move to them? I cant import a SQL dump as it tells me it is the wrong version, what other problems am I likely to occur and how can I import the existing database? |
|
Latest Blog Post :
Tony Stewart #14 Square Cooler Coozie
|
|
| |
|
    Joined: Jan 2006 Posts: 6215
Administrator
 
 United States
|
Jul 05, 2008, 12:08:24 AM | #2 |
When you do your MySQL dump from version 5 all you have to do is add the follwing parameter to your mysqldump statement
–compatible=mysql40 |
|
Latest Blog Post :
8 Tips for Creating a Marketing Buzz
|
|
|
 Joined: Mar 2008 Posts: 45
 
 United States
|
Sep 16, 2008, 07:39:31 PM | #3 |
| Thanks for the information. Sorry for taking so long to get back about this but it worked perfectly. |
|
Latest Blog Post :
Tony Stewart #14 Square Cooler Coozie
|
|
|
 |
|
Pages: [1]
|
|
|
 |