Announcement

Collapse
No announcement yet.

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

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

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

    I have 2 problems. The first is the common:

    Code:
     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.

  • #2
    1. Run tthese queries:

    DROP TABLE IF EXISTS threadviews;

    CREATE TABLE threadviews (
    threadid INT UNSIGNED NOT NULL DEFAULT '0',
    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:

    Backup:
    http://www.vbulletin.com/docs/html/m...nce_ssh_backup

    Restore:
    http://www.vbulletin.com/docs/html/m...ce_ssh_restore

    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.
    backups
    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

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