table corrupted

[keat63]

We had a table get corrupted this week.
Where it should have contained 4300 entries, it only contained 27.
There's been no work that i'm aware of which would have caused this.
Can you suggest any log files which might give me a clue as to why this happened. ?

 

[idpablo]

You can look here. Corrupted Database Tables

 

[ffeingol]

Assuming you are referring to a MySQL table, check /var/log/mysqld.log. Again, assuming it's a MysQL table, have you tried to repair it (command line or phpmyadmin)?

 

[keat63]

The database is quite hefty at 4.5gb. I couldn’t open the backyp to extract just the corrupted table, so ended performing a restore on the whole database through whm, so the database is back up and running.

I'm not sure exactly when the issue occured, I was told it was working on Monday evening and not on Tuesday morning.
I've already looked in mysqld.log and dont see anything of any significance.

2023-04-24T16:50:12.780164Z 185646 [Note] InnoDB: Stopping purge
2023-04-24T16:50:12.782703Z 185646 [Note] InnoDB: Resuming purge
2023-04-24T19:25:01.377336Z 193890 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2023-04-24T19:30:01.309016Z 194058 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2023-04-24T23:25:01.958318Z 198563 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2023-04-24T23:30:01.164060Z 198595 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2023-04-25T01:00:20.816503Z 199679 [Note] InnoDB: Stopping purge
2023-04-25T01:00:20.822729Z 199679 [Note] InnoDB: Resuming purge