The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Need Help Quick Please With Database Back up
Hi
I have to restore my database as it has got hacked into. I have a recent back up i can use but i keep getting the following error when i try to import it. Code:
Error There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unknown Punctuation String @ 7 STR: />< SQL: <br /><strong>Warning</strong>: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in <strong>[path]/includes/class_core.php</strong> on line <strong>408</strong><br /><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <title>CashLoopholes Database Error</title> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" /> <style type="text/css"> <!-- body { background-color: white; SQL query: Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408 Any help is very much appreciated. |
#2
|
|||
|
|||
How was this backup created?
Was it transfered from your PC to the server? |
#3
|
||||
|
||||
It was made via the back up database bit in the vbulletin admincp
|
#4
|
||||
|
||||
can nobody help me with this please
|
#5
|
||||
|
||||
What method are you using to import it? Have you tried another method? Do you have any other backups to try this on?
|
#6
|
|||
|
|||
Most hosts do regular backups. Did you contact them to re-install one of their backups?
|
#7
|
|||
|
|||
The AdminCP is not a reliable backup for anything but very small boards.
The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here: Backup: http://www.vbulletin.com/docs/html/m...nce_ssh_backup Restore: http://www.vbulletin.com/docs/html/m...ce_ssh_restore P.S. If you don't have shell access, some people have also reported success with these scripts: MySQLDumper: http://www.mysqldumper.de/en/index.php MySQLHotxcopy: http://www.vbulletin.com/forum/showt...t=mysqlhotcopy Bigdump: http://www.ozerov.de/bigdump.php |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|