move mysql 3.23 database to mysql 5.0
Posted on 2006-06-11
I am having trouble moving a database from mysql 3.23 to version 5.0. The old computer is linux and the new computer is Windows XP. Can anyone help or offer advice?
old computer> mysqldump bryanh > bryanh.sql
then I use the "scp" linux command to copy the file. Then on the new computer I have the below.
E:\temp>mysql -u root -ppassword bryanh < bryanh.sql
ERROR 1064 (42000) at line 84: You have an error in your SQL syntax; check the m
anual that corresponds to your MySQL server version for the right syntax to use
near 'decimal(6,0) NOT NULL default '0',
payee varchar(20) NOT NULL,
amount decima' at line 2