Sunday, December 26, 2010

Error: log file /mysql/data/mysqld/ib_logfile0 is of different size


I have got the below error while starting the mysql after configuring a new slave with the tall ball of the master data directory.

081022 6:24:41 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
081022 6:24:41 /usr/local/mysql4020/libexec/mysqld: Shutdown Complete

InnoDB: Error: log file /mysql/data/mysqld/ib_logfile0 is of different size 0 209715200 bytes
InnoDB: than specified in the .cnf file 0 104857600 bytes!
081022 6:24:42 Can’t init databases
081022 6:24:42 Aborting

Solution :

The same has been resolved by changing the below variable in the cnf file as same in the master config file

innodb_log_file_size = 200M

No comments:

Post a Comment