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 words.
Carlos
On 9/26/06, Curious George [EMAIL PROTECTED] wrote:
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 server version for the right
syntax to use near '77, 137289, 4)' at line 1
When I look at the file using vi, I see lots of ^M (all over the place). I
believe that these are DOS line breaks and I know how to get rid of them,
but it is a 35MB file and I don't know if I can do it over my slow
connection from home (via SSH).
My question is: are those ^Ms my problem? Or is that normal and I have
some other issue?
Thanks in advance for any pointers.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]