Community Server >> VBulletin

[emdee]

Hi,

i recetnly migrated a community server forum to vbulletin.

in order accomplish this i had to host both the target (CS) and destination (VB) database on the same Windows server - (so IMPEX could read the CS's MSSQL database directly off the same host's servers).

now that i have the VB forum up and running, i am trying to move the VB to my linux hosting.

i backed up the VB database from the windows host as a .sql file and imported it to the linux host, via phpmyadmin (i think thats what its called)

now the vb forum in not loading
i keep getting DB errors as shown below.

2 things i have noticed;

1: the number of tables in the database is too few: its like 81 tables,
as opposed to 148 tables that i have for my other VB forums on with my linux host

2: the db type is InnoDB as opposed to MyISAM for my other VB forums on with my linux host


Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT *
FROM session
WHERE userid = 0
AND host = '66.249.16.212'
AND idhash = '2733525bdb96fe767d7d5999513e70f9'
LIMIT 1;

MySQL Error : Table 'gameonme_sbnet2.session' doesn't exist
Error Number : 1146
Request Date : Monday, May 4th 2009 @ 01:16:32 PM
Error Date : Monday, May 4th 2009 @ 01:16:32 PM
Script : http://www.thedomain.net/forums/ (http://www.thedomain.net/forums/)
Referrer :
IP Address : 66.249.16.212
Username :
Classname : vB_Database
MySQL Version :

please advise as to what to do

[Steve Machol]

You have an incomplete database. You need to make a new backup.

The only consistently 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 timeout 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

If you don't have telnet or SSH access, some people have 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

[emdee]

MySQLDumper worked ok.

thanks