Sample Header Ad - 728x90

mysql table tables_priv index is corrupted and the best possible way to repair it

0 votes
1 answer
470 views
I am using MySQL with XAMPP. For sometime now I keep getting a server unavailable error and upon digging deeper I noticed that my mysql.tables_priv table index is corrupted (ARIA Database Type). I have tried running aria_chk and myisamchk to repair, but to no avail. I have also tried mysql_upgrade but again this didn't help. The only thing I can think of now is to manually remove the tables_priv.MAD file from xampp\mysql\data\mysql folder, create an empty one and REPAIR TABLE tables_priv. Can you kindly advise if that is the right and safe approach to take? Also, if you have any other suggestion then please do mention.
Asked by Girish Agarwal (1 rep)
Aug 20, 2023, 11:38 PM
Last activity: May 6, 2025, 11:02 AM