InnoDB: Error: log file. and ib_logfile0 is of different size 0 5242880 bytes problem in Mysql startup
- 2020-05-10 23:02:02
- OfStack
If your profile USES something like my-innodb-heavy-4G.cnf.
Mysql starts normally, but innodb's tables are not available
In the error log you will see the following output:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
Now all you need to do is back up the ib_logfile× of the original innodb to a directory, then delete the original files and restart mysql.
You will see that the ib_logfile* size becomes the size specified in your configuration file.
my-innodb-heavy-4G.cnf (the size of log file is 256M: innodb_log_file_size = 256M)
You will see many files of size 268435456.
Mysql starts normally, but innodb's tables are not available
In the error log you will see the following output:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
Now all you need to do is back up the ib_logfile× of the original innodb to a directory, then delete the original files and restart mysql.
You will see that the ib_logfile* size becomes the size specified in your configuration file.
my-innodb-heavy-4G.cnf (the size of log file is 256M: innodb_log_file_size = 256M)
You will see many files of size 268435456.