MySQL Database Import

sbb · 06-03-2006, 08:31 AM

Hello

I'm trying to import a database backup which I made, called raven.sql

I tried to import it using the following command:

Code:

mysql -u root -p raven < raven.sql

But it gave me this error

Code:

ERROR 1064 at line 21: 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 'DEFAULT CHARSET=latin1' at line 11

So I went to line 11 and it contains this!

Code:

 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

I'm very confused... please help!

zaichik · 06-04-2006, 11:15 AM

It sounds like you are trying to restore a version of a database from a later version of MySQL to an earlier version. What are the versions involved here?