Repair corruct MYSQL tables

Did you ever get the message: followed with a body like this:

DATABASE-NAME.cache_menu
warning  : 1 client is using or hasn't closed the table properly
DATABASE-NAME.captcha_sessions
warning  : 1 client is using or hasn't closed the table properly

 Improperly closed tables are also reported if clients are accessing
 the tables *now*. A list of current connections is below.

+----+------------------+-----------+----+---------+------+-------+------------------+
| Id | User             | Host      | db | Command | Time | State | Info             |
+----+------------------+-----------+----+---------+------+-------+------------------+
| 13 | debian-sys-maint | localhost |    | Query   | 0    |       | show processlist |
+----+------------------+-----------+----+---------+------+-------+------------------+
Uptime: 148  Threads: 1  Questions: 2633  Slow queries: 1  Opens: 1331
Flush tables: 1  Open tables: 64  Queries per second avg: 17.791 

Where DATABASE-NAME is the name of your corrupt database.

Than this is the fasted solution to solve.

mysqlcheck -p -A --auto-repair

Post new comment
The content of this field is kept private and will not be shown publicly.
CAPTCHA
Deze vraag is om te controleren of u een persoon bent. Di is om spam berichten tegen te gaan.