Today, when I turned on the PC and started the Xampp, I saw that there are certain tables that I use and I can not access them or repair them if I select them.
And it gives an error to access them.
How can I access them or repair them?
Thanks greetings.
There are multiple possibilities for which the "IN USE" tables can be. One of the most common problems is that they have been corrupted in some way or there is a process that blocks them. In this case, try the following:
REPAIR TABLE 'table_name'
_
In some situations, it does not matter how many times REPAIR is executed, the table still returns EN USO and the worst is that the system says "already updated" .
If you have access shell , here's what you should do:
$ cd /var/lib/mysql/DATABASE
$ myisamchk --safe-recover TABLE
Where DATABASE is the one you are trying to fix.
This will repair the table in safemode and SHOULD result.