Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 06-03-2006, 09:31 AM   #1
LQ Newbie
Registered: Aug 2003
Distribution: Fedora 4
Posts: 27

Rep: Reputation: 15
MySQL Database Import


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

I tried to import it using the following command:

mysql -u root -p raven < raven.sql
But it gave me this error

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!

I'm very confused... please help!
Old 06-04-2006, 12:15 PM   #2
Registered: May 2004
Location: Iowa USA
Distribution: CentOS
Posts: 419

Rep: Reputation: 30
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?


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL import database akines Linux - Software 3 04-19-2006 02:14 AM
How to import a mysql database from backup WindowBreaker Slackware 6 03-17-2006 12:08 AM
Import Database Function Script Using Perl?? domquem Programming 3 01-13-2005 10:05 AM
Exporting MySQL error when trying to Import to another database. strez4prez Linux - Software 0 05-28-2004 12:43 PM
Import records to MySQL Database from a shell script chrisk5527 Linux - General 12 03-24-2004 10:49 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:40 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration