WARNING: mysqlcheck has found corrupt tables
Witam.
Wiecie może jak naprawić bazę danych ??? Nie wyświetla mi teraz statystyk. Problem pojawił się po nagłym zaniku prądu.
lms.cash warning : 1 client is using or hasn't closed the table properly lms.customerassignments warning : 1 client is using or hasn't closed the table properly lms.dbinfo warning : 1 client is using or hasn't closed the table properly lms.hosts warning : 1 client is using or hasn't closed the table properly lms.nodes warning : 1 client is using or hasn't closed the table properly lms.sessions warning : 1 client is using or hasn't closed the table properly lms.stats warning : 1 client is using or hasn't closed the table properly error : Can't read key from filepos: 18789376 error : Corrupt lms.timestamps warning : 1 client is using or hasn't closed the table properly lms.users 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 | +----+------------------+-----------+----+---------+------+-------+--------- ---------+ | 6 | debian-sys-maint | localhost | | Query | 0 | | show processlist | +----+------------------+-----------+----+---------+------+-------+--------- ---------+ Uptime: 5 Threads: 1 Questions: 200 Slow queries: 0 Opens: 193 Flush tables: 1 Open tables: 64 Queries per second avg: 40.000
Pozdrawiam.
_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms
uczestnicy (1)
-
Maricn