SQL errors. - i need a guru's help here

[BlackDeath]

ok, here's my situation. about once a week i get error's which indicate my db is corrupt. my host is able to fix it but it keeps hosing itself up. my host says its because when i moved from an old host to my current one, the old host was using sql 3 and the new one is using 4. this caused an error. he says the only way would be to basically wipe out the current db. well i have 1800 members and 5000 threads and 48,000 posts. i could do losing the posts but not the member's list. is there a way to extract the members list only and put it into a new install of the db? thanks in advance for the help.

[Steve Machol]

Read this thread:

http://www.vbulletin.com/forum/showthread.php?threadid=69803

If you're on mysql 4.0.12 try using mysqldump to create a sql backup your database - mysqldump guide at http://www.sitepoint.com/article/678

Then create a new empty database name and import the mysql sql backup back into the empty database, and edit config.php to point to the new database

Also take a read of

http://www.mysql.com/doc/en/Corrupted_MyISAM_tables.html

and

http://www.vbulletin.com/forum/showthread.php?threadid=69803