LinuxQuestions.org - MySQL Database Import

- Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)

- - MySQL Database Import (https://www.linuxquestions.org/questions/linux-software-2/mysql-database-import-451182/)

MySQL Database Import

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!

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?