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.
Convert MySQL dump from 4.0 to 4.1 [SOLVED]
Moderator: General Moderators
- 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]
Last edited by Pyrite on Fri Jun 02, 2006 12:50 am, edited 1 time in total.
- Pyrite
- Forum Regular
- Posts: 769
- Joined: Tue Sep 23, 2003 11:07 pm
- Location: The Republic of Texas
- Contact:
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.
So I just added some backquotes around "People Catagory" and it worked. Thanks anyways!
Code: Select all
UNIQUE KEY People Catagory (catlink_uid,catlink_cid)