Which tables to transfer over [Archive]

View Full Version : Which tables to transfer over

JPforFree

12-15-2008, 08:13 AM

We are changing hosts, which tables should I import from our database, to transfer over members list, posts, forums etc.

Dismounted

12-15-2008, 08:25 AM

All of them, if you want to keep everything.

JPforFree

12-15-2008, 08:39 AM

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:

 Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in [path]/includes/class_core.php on line 408 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>TDRgaming.com | Forums 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

when importing the .sql file backup, I get this error, anyone have a clue as to what its meaning is?

Marco van Herwaarden

12-15-2008, 08:49 AM

How was the backup created?
How is it restored?
What is the MySQL version on both servers?
How was the backup file transfered to the new host?

JPforFree

12-15-2008, 02:31 PM

Through both phpmyadmin, and through the admincp (both got super similar errors)
Through PhPmyadmin
ver. 5.0.67
When you say backupfile...which are you asking about?

SEOvB

12-15-2008, 07:14 PM

Through both phpmyadmin, and through the admincp (both got super similar errors)
Through PhPmyadmin
ver. 5.0.67
When you say backupfile...which are you asking about?

How large was the backup, phpMyAdmin can sometimes cause errors larger backups. SSH using mysql dump is the preferred method.

Are both the old host, and the new host using 5.0.67 MySQL

When you created the backup, you should have gotten a .sql or a .sql.gz file to restore on your new host. Did you upload it using a FTP, or are you trying to restore via phpMyAdmin?

Marco van Herwaarden

12-16-2008, 07:23 AM

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