MySql Syntax Error on Import

[thumbsucker]

Hi,

I am moving servers from my old one to my new one.

I exported a backup sql file from my old server.  It is running MYSQL 4.1.12

Then I tried to import it to my new server.  It is running MYSQL 4.1.20

The error I get is the following:

ERROR 1064 (42000) at line 1710: 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 ''<font s' at line 1

Can anyone tell me what's going on?

[Pierre M.]

Ouch !

Only one idea : character sets. May be one datastore has one and the other another one or the backup has another one ?

Utf-8, ANSI, ASCII, Windows-1252, ISO-8859... the same data becomes something else and its interpretation gets corrupted.

Pierre M.