ibdata1 corrupted, innodb to zabbix frontend

[Moris]

Hi there,

I have been struggling for a week trying to recover my data from mysql innodb.

what happened was that for space issue zabbix start getting warning then database crushed, when we restarted the server mysql didnt start so we tried to manage to do some steps to recover ( actually we didnt have a backup ... biggist mistake) like with ib_logfile and ibdata1 but without success ...
we have the directory of our database intact with all files .frm and .ibd but when we run the mysql we get this error in database :
error: ERROR 1146 (42S02): Table 'zabbix.versiondb' doesn't exist. and with all tables eventhough with show tables i can see all of them.
in the frontend we get :
Database error
The frontend does not match Zabbix database. Current database version (mandatory/optional): 0/0. Required mandatory version: 2020000. Contact your system administrator.

Hope somone could help or lead us to get any zabbix support contact for this issue

Thank U in advance

regards,

[bernard]

Disable InnoDB log file size custom setting

I disabled "innodb_log_file_size" from /etc/my.cnf and restart mySQL.

#innodb_log_file_size = 64M

I cannot explain why. I got this settings on my old Zabbix server, but it doesn't work anymore on my new installation. Is it Zabbix or mySQL issue