MySQL Forums
Forum List  »  Newbie

Import Problem with dashes
Posted by: Richard Redd
Date: June 25, 2005 05:48PM

I've got a mysql export file as a result of a mysqldump command with --all-databases. After wiping the drive and installing the system from scratch, I'm trying to import the data back in with this file. Running the command "mysql -u root -p < mysql-export" gives me the following error:

"ERROR 1064 at line 640572: 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 '-Dev' at line 1"

After doing to searching, it looks like the dashes in some of my database names are the culprit. I'd rather not change the database names. Is there some workaround I can do like escaping these dashes?

The old database was 4.0.11a-gamma-log and the new one is 4.0.24.

Thanks for any help.

Options: ReplyQuote


Subject
Written By
Posted
Import Problem with dashes
June 25, 2005 05:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.