Error 1064 when importing 4.0 dump into 4.1 via command line

2006-09-26 Thread Curious George
I dumped a database from a 4.0 mysql and am attempting to move it to a server running 4.1 - using the command line: $ mysql -u root -pmypassword empty4.1db < 4.0dump.sql The result: ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL

Re: Error 1064 when importing 4.0 dump into 4.1 via command line

2006-09-26 Thread Carlos Proal
I dont think that is the problem but, what do you mean by a slow connection ?, you cant run the dos2unix command on the remote server ? The error ocurred on line 2, did you see any special word in that line ? can you share with us that line? , remember that each version may can reserve different