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

[matrlx]

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!

[Steve Machol]

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/maintenance_ssh_backup

Restore:

http://www.vbulletin.com/docs/html/maintenance_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