Monday, September 17, 2018

mysql incorrect information in file corrupt error

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.frmpoller_item.MYDpoller_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.MYDpoller_item.MYI into the datadir
  • Start MySQL again