[Forum] getting an Error error when tryin to get my host to restore one of my sites db

[Shadow Demon]

here's the error my host gets when they try to restore my other sites db,

ERROR 1064 (42000) at line 104: 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 'DROP TABLE IF EXISTS `adminhelp`' at line 6;

can you guys help me to fix this error so my host can restore my other sites db?

TY!^ ^

- - - Updated - - -

Bump

[Andy]

When seeking troubleshooting help, it's important to provide more information, such as what you are wanting to do.

[Shadow Demon]

When seeking troubleshooting help, it's important to provide more information, such as what you are wanting to do.

Sorry, I've trying to restore my site back to the way it was before in got ****ed up, reason I'm tryin to restore it is because I meant to access the upgrade script page but incidentally ran the install script page and whipped my site completely clean but when my host tried restoring the db the guy got this db error.

ERROR 1064 (42000) at line 104: 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 'DROP TABLE IF EXISTS `adminhelp`' at line 6;

so can you guys help me fix that db error plz?


Thank you!

Sean

[Abdulla Ashoor]

You need to try to import your database with other options rather than shell.

Bigdump:

http://www.ozerov.de/bigdump.php

MySQLDumper:

http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:

http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

The hosting guy should have enough experience to solve this or maybe your backup is corrupted anyway.

[Andy]

Hi Sean,

How was you backup created? How many posts does your forum have?

There is the possibility that your backup might be incomplete in which case you will not be able to recover from this mistake.

[borbole]

here's the error my host gets when they try to restore my other sites db,

ERROR 1064 (42000) at line 104: 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 'DROP TABLE IF EXISTS `adminhelp`' at line 6;

can you guys help me to fix this error so my host can restore my other sites db?

TY!^ ^

- - - Updated - - -

Bump

How is your host trying to restore your backup?

P.s. Can you copy/paste here the code for the adminhelp table from the backup btw? Or you could try this, open up your backup sql file and then remove completely the codes that adds the adminhelp table, save the changes and give the restore another go. And when the restore is completed, re-add the adminhelp table manually in the db. You can take it structure from the mysql-schema.php file inside the install folder.

[Amaury]

For reference, this is the forum Sean is talking about (it's his brother's forum), which, before this happened, was running vBulletin 4.1.12.

If I recall correctly, there were three threads, with one post in each.

[Shadow Demon]

Hi Sean,

How was you backup created? How many posts does your forum have?

There is the possibility that your backup might be incomplete in which case you will not be able to recover from this mistake.

tbh its still fairly new and I used a thing on my host that allows me to backup or restore stuff on both sites and I chose to back it up.=/

[Andy]

tbh its still fairly new and I used a thing on my host that allows me to backup or restore stuff on both sites and I chose to back it up.=/

This is the best way to backup and restore.

https://www.vbulletin.com/docs/html/main/maintenance_ssh_backup

https://www.vbulletin.com/docs/html/main/maintenance_ssh_restore