MyBB Community Forums

You can repair your tab;e form SSH, this wil do your job... Follow this step by step :-

1). Login to your server as root.
2). The database table can be repaired only if the Mysql server is in running status.Type the following command:-

root# /etc/init.d/mysql status

3). Now, login to the MySQL database for a required user.

mysql> mysql –u databaseusername –p databasename

4). Select the MYBB databse name :-

mysql> use MYBBdatabasename;

5). Now, you will have to check whether the table is corrupted. After typeing this command if it gives NULL value than it means it is corrupted in your case which it was.

mysql> check table tablename;

e.g, tablename :- MYBB_posts


6). Repair table command :-

mysql> repair table tablename;

In your case,

mysql> repair table MYBB_posts;

Have Fun

(2011-01-18, 02:34 AM)Derek M. Wrote: [ -> ]We know you're using Webmin.. Is there an option on there called Phpmyadmin? How did you make the database the forum runs on..?

By ssh and dumper script.

(2011-01-18, 02:43 AM)grave Wrote: [ -> ]You can repair your tab;e form SSH, this wil do your job... Follow this step by step :-

1). Login to your server as root.
2). The database table can be repaired only if the Mysql server is in running status.Type the following command:-

root# /etc/init.d/mysql status

3). Now, login to the MySQL database for a required user.

mysql> mysql –u databaseusername –p databasename

4). Select the MYBB databse name :-

mysql> use MYBBdatabasename;

5). Now, you will have to check whether the table is corrupted. After typeing this command if it gives NULL value than it means it is corrupted in your case which it was.

mysql> check table tablename;

e.g, tablename :- MYBB_posts


6). Repair table command :-

mysql> repair table tablename;

In your case,

mysql> repair table MYBB_posts;

Have Fun

wow, really nice reply mate.
thank you, i may try it later .
Regards.

Have fun DoctorX