Announcement

Collapse
No announcement yet.

Community Server >> VBulletin

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

  • emdee
    replied
    MySQLDumper worked ok.

    thanks

    Leave a comment:


  • Steve Machol
    replied
    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

    Leave a comment:


  • emdee
    started a topic Community Server >> VBulletin

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X