Vb database errors - How to fix them ?

[freaky]

I have a pretty high volume UBB board and I am moving over to vbulletin. I have seen several sites that have this software, but often experience database errors, usually a corrupted table or whatever. Does the control panel have something to fix this error ? Or how do you guys usually go about fixing it ? Is there a program I can download somewhere that fixes this ?

Thanks :)
http://www.off-topic.net

[werehere]

You should install Phpmyadmin, it is an interface for Mysql basically, and is written in PHP.

Most of these errors you see are lost connection errors and are related to virtual hosts loosing their connections with their database server. If you have a dedicated host you will be much better off, and probably not experience a whole lot of those little errors.

You may possibly have a sessions table get corrupted once in a while (which is just that sessions = not too important).

[Me2Be]

Hi there!

I moved my UBB which (at the time) had 80,000 posts without a problem. I've had a couple of database corruptions on my current database (over 220,000 posts on my dedicated server) but I ran a couple of commands and it was fixed.

Look for a post by Chris Schreiber that has the command isamchk or something similar to that in the mysql forum. Those are the commands to fix the corruption :)

Welcome!