No announcement yet.

Community Server >> VBulletin

  • Filter
  • Time
  • Show
Clear All
new posts

  • emdee
    MySQLDumper worked ok.


    Leave a comment:

  • 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:



    If you don't have telnet or SSH access, some people have reported success with these scripts:



    Leave a comment:

  • emdee
    started a topic Community Server >> VBulletin

    Community Server >> VBulletin


    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 = ''
                        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=""][COLOR=#0000ff][/COLOR][/URL]
    Referrer      : 
    IP Address    :
    Username      : 
    Classname     : vB_Database
    MySQL Version :
    please advise as to what to do
    Last edited by emdee; Tue 5 May '09, 3:52am.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.