Database repair problem

Portal Home > Knowledgebase > Articles Database > Database repair problem

Posted by ruba, 04-02-2012, 03:37 PM
Dear all, last one week i have been following this problem below: i have using vbulletin 3.8.7, i got some times database error, so i am repair the database via phpmyadmin. then all table is showing 'ok' but cybvilxh_guests table is different, what dose mean this information, and why happen this, kindly explain me. myuser.cronlog repair status OK myuser.customavatar repair status OK myuser.customprofilepic repair status OK myuser..cybvilxh_guests repair warning Number of rows changed from 2737 to 2735 myuser.cybvilxh_guests repair status OK myuser.cyb_logintouser repair status OK myuser.datastore repair status OK
Posted by Infinitnet, 04-03-2012, 11:09 AM
It means that this table has been repaired, the other ones were okay.
Posted by ruba, 04-04-2012, 01:11 PM
but why happened that? its really having my database problem, i have facing this problem last week once in everyday, its was working fine
Posted by Patrick, 04-04-2012, 01:16 PM
Has your server lost power recently? Is MySQL crashing or just giving errors? What errors are you getting with vBulletin?
Posted by LnxtecH, 04-04-2012, 11:22 PM
Most common reason is a crashed mysql server. Your host should be able to help you with this.
Posted by ArturasLIX, 04-05-2012, 02:13 AM
Yep, common reason is a crashed MySQL server with MyISAM storage engine. And because it's not a transaction safe engine like InnoDB, after such crashes with dirty writes tables becomes crashed and they need to be fixed.
Posted by AttackerNET, 04-05-2012, 07:05 AM
This is not necessarily a problem with this table. It means there were some updates added and inserted into that table since the beginning of the repair process you performed. So, The ideal method is to turn off your script before running repairs.