Error When Importing DB Backup Into a New DB

Client Joined: Sep 10, 2004 Posts: 166

I have two nuke accounts here, one primary domain and one addon for another domain. I backed up my primary DB and files so I could create the second domain. However after I created the new DB, new DB user and added the user to the DB, and then tried to import the data using MyphpAdmin, I get the followng error message:

Error

SQL-query :

--
--

MySQL said:

#1064 - 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 '--' at line 2

Any ideas or suggestions would be greatly appreciated.

Thank you!

Brent

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

The chances are the first line in your backup file was NOT a comment but a line added by phpMyAdmin. What is the first line in your backup file?

Posted: Wed Sep 22, 2004 1:46 pm

The first two lines are:

-- MySQL dump 9.11
--

Posted: Wed Sep 22, 2004 1:50 pm

you need to change all instances of -- to ## Did you do that backup off of phpMyAdmin? I know that's a problem and somewhere I have a note on this but it's not handy. Anyway, do a mass change on -- to ##.

Posted: Wed Sep 22, 2004 2:24 pm

Thanks, that worked. Any idea when this will be fixed?

Thanks,

Brent

Posted: Wed Sep 22, 2004 2:36 pm

No. I think it's a phpMyAdmin issue but I'n not sure.