table corrupted

keat63

• April 26, 2023 03:02

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

  • April 26, 2023 13:05

  You can look here.

  0
• 

  ffeingol

  • April 26, 2023 14:03

  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)?

  0
• 

  keat63

  • April 26, 2023 20:19

  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
  

  0

Please sign in to leave a comment.