https://serverfault.com/questions/422507/mysql-incorrect-information-in-file-corrupt-error
Incorrect information in file: './cacti/poller_item.frm'
.frm
file stores the table format. Try this:
- Stop MySQL
- Take the backup of
poller_item.frm
, poller_item.MYD
, poller_item.MYI
- Drop the
poller_item
table
- Start MySQL
- Recreate
poller_item
table by using CREATE TABLE
statement in cacti.sql (uses the corresponding version that you're running)
- Stop MySQL
- Copy the
poller_item.MYD
, poller_item.MYI
into the datadir
- Start MySQL again
No comments :
Post a Comment