[Error Message] MyBB is automatically repairing a crashed table

[kbilly]

This user has been denied support.

Hello!

I renamed the table using;

RENAME TABLE  mybbmm_privatemessages  TO  mybbmm_privatemessages_copy;

But how to do this:

copy the renamed table to

mybbmm_privatemessages

Could you please explain?

Because it gives me error, table doesn't exist and i can also understand it because the name has been changed.

As i couldn't bear my forum offline for that much time, i have emptied the table in phpMyadmin and diabled the tablescheck in taskmanager till the solution is found. Every automatic repair is sending my board offline because the table can't be repaired.

I'm aware, i have lost the messages but they can be stored using the backup.

Thanks a lot.

[Crazycat]

From phpMyAdmin, go to the mybbmm_privatemessages_copy table, and in the operation' tab, you'll have the option "copy to"

[kbilly]

This user has been denied support.

Hello!

The forum was online in the last hours without table check in task manager.

So, i have tried as you told me, it still doesn't repair it.

Please check the screenshot.

Thanks a lot.

   

[Crazycat]

Have a look to https://www.databasefilerecovery.com/blo...ailed.html and/or https://stackoverflow.com/questions/8843...air-failed

Google is your friend, the trouble is not related to MyBB but to your MySQL server

[kbilly]

This user has been denied support.

Hello Crazycat!

First of all a BIG thanks to you for assisting me. It was clear to me that the problem wasn't not the MyBB but MySQL server.

So, i was also trying to do everything to repair it. As you suggested, i used Google too to find a solution but not every solution is the same because not every problem is the same.

I followed the two links you mentioned, plus one another link i was following since the problem started.

I would gladly post them here, to help others, in case, they face my same issue.

The solution is a mixture of the reading of the various threads and the suggestions from the terminal while running the commands.

So, what i did is the following:

Run in terminal:

mysqladmin shutdown

cd /var/lib/mysql/databasename

myisamchk -f  tablename

-f = force repair; which worked for me.
-o = safe recover; which didn't work for me.

Then i started MySql server and checked the database in cpanel, every single table is fine, no crashes nothing.

Then i re-activated the table check task in the task manager, no crashes, nothing.

The error i made, was yesterday, when i used the emply button in phpmyadmin to get my forum online, which lead the deletion of the old private messages. The above solution could have saved them, perhaps.

But that's not that big problem as my forum is online now and working fine.

In case, i have any kind of issue regarding the crashes, i will be updating here, in opposite case, the thread can be closed.

Thanks a lot again.

Kind regards.