Portal Home > Knowledgebase > Articles Database > Getting error while restoring database.
Getting error while restoring database.
Posted by kingofdevils, 02-05-2008, 04:58 PM |
SQL query:
/*!40000 ALTER TABLE `qhvbmailer_attachments` DISABLE KEYS */;
MySQL said: Documentation
#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 ';
UNLOCK TABLES;
--
-- Table structure for table `qhvbmailer_campaigns`
--
DRO' at line 1
Can any one please help me.
|
Posted by ServerSurgeon George, 02-06-2008, 03:19 AM |
the error speaks by itself
you have a syntax error and it says where
|
Posted by david510, 02-06-2008, 10:43 AM |
Are you trying to restore a database backup file taken from a higher mysql version on a 4.0 server?
|
Posted by kingofdevils, 02-07-2008, 03:16 AM |
plz explain wht exactly is to be done.
wht to edit in database.
Kindly help me.
|
Posted by kingofdevils, 02-07-2008, 12:06 PM |
Anyone plz help..
|
Posted by foobic, 02-07-2008, 07:22 PM |
Open the sql file in a text editor (not Word / Wordpad etc.) and make sure there are no invisible special characters at the beginning.
|
Posted by SparkSupport, 02-08-2008, 05:20 AM |
It seems like you are trying to restore the db on a newer version of mysql server. Please check whether the syntaxes of your sql backup server ( on which the backup file is generated ) and sql server ( on which you trying to restore ) are compatible.
|
Posted by YYamagishi, 02-08-2008, 06:06 AM |
You would have to tell us:
1) Version of your current MySQL Daemon
2) Version of your previous MySQL Daemon
|
Posted by vikimathew, 02-08-2008, 06:49 AM |
You need to tell the default character set also.
|
Add to Favourites Print this Article
Also Read