Problems migrating DB from MySQL 3.23.58 to MySQL 4.1.15-Debian_1-log
 

OK so strange problem

My current vB and database are running on quite an old system mysql 3.23.58

I'm using the following command to backup the DB contents into a text file
mysqldump --opt -c --all --extended-insert -u hinch -p hinch_main > faSQLdump.sql

Now the machine I'm trying to move to is 4.1.15-Debian_1-log

when i try to import the database using mysql -u root -p faold < faSQLdump.sql
I get a nice little error

ERROR 1064 (42000) at line 514: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group varchar(16) NOT NULL default '',
online int(1) default '0',
last_onlin' at line 12

I'm assuming this is caused by the way mysql is outputting the backup .sql file in the first place have i missed some flags out I should have put on the mysql dump command? Is there a better/easier way of doing this migration?

you could simply copy the myd files to the new server and run the upgrade afterwards, that's what i do locally normally

normally i would just copy across and upgrade that way my problem is the current server is a shared server which i dont have access to the myd files from.

so I have to rely on the mysql backup proc stuff