PDA

View Full Version : Need Help Quick Please With Database Back up

gwerzal
08-28-2008, 02:42 PM
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.

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

Anybody know why it is not working or where i am going wrong.

Any help is very much appreciated.
Marco van Herwaarden
08-29-2008, 08:35 AM
How was this backup created?
Was it transfered from your PC to the server?
gwerzal
08-29-2008, 10:20 AM
It was made via the back up database bit in the vbulletin admincp
gwerzal
09-01-2008, 02:27 PM
can nobody help me with this please
Lynne
09-01-2008, 02:33 PM
What method are you using to import it? Have you tried another method? Do you have any other backups to try this on?
douffle
09-01-2008, 06:51 PM
Most hosts do regular backups. Did you contact them to re-install one of their backups?
Marco van Herwaarden
09-02-2008, 08:43 AM
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/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_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/showthread.php?t=134821&highlight=mysqlhotcopy

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