Moving the forum DB to a new server, plz help!

  • Time
  • Show
Clear All
new posts
  • matrlx
    New Member
    • Oct 2005
    • 15
    • 3.0.7

    Moving the forum DB to a new server, plz help!

    I have 2 problems. The first is the common:

     Invalid SQL: SHOW CREATE TABLE threadviews
     mysql error: Can't find file:  'threadviews.MYD' (errno: 2) 
    mysql error number: 1017
    I've ran the drop threadviews table SQL query many times, but I still get this error as I try to run maintaince from within the admin cp of VBulletin.

    Next problem is that I wish to move the DB to a new server. The problem is, I can't. I've tried exporting the whole db, but then I get an error at the adminmyphp page. I've tried exporting/importing one table, which worked.
    But when I try to import the whole thing, either as a DB as a whole, or as tables, it wont work.

    I can't do it through a command prompt either, as it seems my FREEBSD 4.x server doesn't have mysql command installed.

    I've also tried creating a backup from within vbulletin. Then it seems to be working for a long time (in myphpadmin), but finally it stops, and the result is nothing, not even a success/fail message.

    Please help me on this I'm currently renting 2 servers, so I need to solve this matter asap!
    Last edited by matrlx; Tue 20 Dec '05, 12:42pm.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    1. Run tthese queries:

    DROP TABLE IF EXISTS threadviews;

    CREATE TABLE threadviews (
    KEY threadid (threadid)

    2. The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:



    This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result inPHP timeouts errors and an incomplete backup file.
    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.


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