Convert MySQL dump from 4.0 to 4.1 [SOLVED]

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Convert MySQL dump from 4.0 to 4.1 [SOLVED]

Post by Pyrite »

I have a db backup dump file from MySQL 4.0 that I need to import into MySQL 4.1, is there some kind of utility program to convert the sql dump file to be compatible to import into 4.1?

Thanks.
Last edited by Pyrite on Fri Jun 02, 2006 12:50 am, edited 1 time in total.
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

unless you want to use some kind of variable collation, you shouldn't need to worry about it.

it will default to whatever the character set of the table is.
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

phpMyAdmin gives an error trying to import the dump that was dumped from 4.0. Hence, my question.
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

what is the error?
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

if it's a collation error, you might have to change the char set to something different...(ie from utf8 to latin1_swedish) etc.
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

Ok, I fixed it. The error was in one of the create table commands, apparently, it doesn't like not to have backquotes around the unique key name.

Code: Select all

UNIQUE KEY People Catagory (catlink_uid,catlink_cid)
So I just added some backquotes around "People Catagory" and it worked. Thanks anyways!
Post Reply