Welcome, Guest. Please login or register.
Did you miss your activation email?
Jan 05, 2009, 09:44:52 PM

Opportunity is missed by most people because it is dressed in overalls and looks like work.

- Thomas Edison

Home

Help

Welcome Guest - Register or Login Now to remove these advertisments

Registration is completely free and only takes a few minutes to signup !

Entrepreneur Forum > Webmasters - Discuss Making Money Online > Website Design and Maintenance > Database

moving host, different MySQL version?

0 Members and 1 Guest are viewing this topic.

Pages: [1]

Author

Topic: moving host, different MySQL version? (Read 374 times)

GilbertGiles

New Member

Joined: Mar 2008
Posts: 22

$View GilbertGiles\s Profile$
GilbertGiles is from United States

United States

Mar 21, 2008, 12:09:41 AM

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?

~Dave~

Administrator

Joined: Jan 2006
Posts: 6186

Building a Foundation

$View ~Dave~\s Profile$

United States

Jul 05, 2008, 12:08:24 AM

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 : Social Media Optimization for Social Media Marketing

Best Affiliate Programs Ξ Recommend Us Ξ Blogger Forum

GilbertGiles

New Member

Joined: Mar 2008
Posts: 22

$View GilbertGiles\s Profile$
GilbertGiles is from United States

United States

Sep 16, 2008, 07:39:31 PM

Thanks for the information. Sorry for taking so long to get back about this but it worked perfectly.

Pages: [1]