I'm not sure if this is the correct way to post, my apologies if it's not.. Anyway, I have a zabbix system on a mysql database where the ibdata1 file grew to 93GB and filled up the disk. Restarting mysql results in:
/etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full! This db is on its own partition, so I can't delete logs or anything else to clear up space. So I moved ib_logfile0 and ib_logfile1 to /tmp to clear 10 megs, and restart. mysql started but everything is out of sync now. ERROR 1033 (HY000): Incorrect information in file: './zabbix/users.frm' and similar for any tables I try to desc, select, etc. I put [mysqld] innodb_force_recovery = 4 and tried every number from 1-8 in /etc/mysql/my.cnf. I just took this job and there is no backup of this database. Any command I issue in mysql results in: ERROR 1033 (HY000): Incorrect information in file: './zabbix/users.frm' for any table in zabbix. mysql> repair table users; +--------------+--------+----------+-----------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------+--------+----------+-----------------------------------------------------+ | zabbix.users | repair | Error | Incorrect information in file: './zabbix/users.frm' | | zabbix.users | repair | error | Corrupt | +--------------+--------+----------+-----------------------------------------------------+ 2 rows in set (0.01 sec) mysql> Is this 'game over' or can this data be recovered in any way? Thanks,
