Announcement

Collapse
No announcement yet.

Community Server >> VBulletin

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Community Server >> VBulletin

    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

    Code:
    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        : [URL="http://www.thedomain.net/forums/"][COLOR=#0000ff]http://www.thedomain.net/forums/[/COLOR][/URL]
    Referrer      : 
    IP Address    : 66.249.16.212
    Username      : 
    Classname     : vB_Database
    MySQL Version :
    please advise as to what to do
    Last edited by emdee; Tue 5 May '09, 3:52am.

  • #2
    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/m...nce_ssh_backup

    Restore:
    http://www.vbulletin.com/docs/html/m...ce_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/showt...t=mysqlhotcopy
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      MySQLDumper worked ok.

      thanks

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X