I ran the following sqldump call in a MySQL 5.7 instance (Windows OS):
I copied the result in a MySQL 5.7 instance (Linux OS), and executed it via:
But I got the following error:
ERROR 1064 (42000) at line 813: 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 '917,0.31000000,267.21000000,'2015-07-08 17:44:39',88758,'BK1','BK1',49208,4921' at line 1
There are some characters in the error message that I haven't been able to copy, so I paste an image here:
So I open the (big) file in nano, and I find the fragment which has this weird characters:
As you can see, it seems the first value of a row seems to have a weird element ^T9^R17 instead of a normal integer like the row before (49171).
Tried to run dos2unix on the file as recommended by @Verace, and this is the result:
Why is this happening? The type of the first column is bigint(20) NOT NULL.