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