PROBLEM:

I’m migrating my data base. I used to have MySQL 4.0.20 and my database run very well on it, but now I install MySQL 5.0 and I have problems restoring the database.
Before instal MySQL 5 I make a DUMP typing >mysqldump -u username -p -h hostname DBname > file.sql
that give me a 100MB file that I save and upload after install MySQL 5. To restore it I typed > mysql -u username -p -h hostname DBname < file.sql but I got this message:

ERROR 1064 (42000) at line 55192: 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 ‘restrict varchar(255) default NULL,
limits varchar(255) default NULL,
refere’ at line 6

SOLVE:

RESTRICT is now a reserved word. Edit your dumpfile to enclose this name in backticks, e.g. `restrict`.