Page 1 of 1

Convert MySQL dump from 4.0 to 4.1 [SOLVED]

Posted: Thu Jun 01, 2006 10:22 pm
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.

Posted: Thu Jun 01, 2006 10:28 pm
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.

Posted: Thu Jun 01, 2006 11:03 pm
by Pyrite
phpMyAdmin gives an error trying to import the dump that was dumped from 4.0. Hence, my question.

Posted: Thu Jun 01, 2006 11:06 pm
by Burrito
what is the error?

Posted: Thu Jun 01, 2006 11:09 pm
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.

Posted: Fri Jun 02, 2006 12:49 am
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!