1
I'm trying to restore a MySQL database from a dead HD. I've followed the instructions from here about copying the old files: https://stackoverflow.com/questions/40479395/export-mysql-datatabase-from-a-dead-hard-drive-xampp but I'm getting the following message in my error log:
170114 22:21:07 [Note] Plugin 'FEDERATED' is disabled.
170114 22:21:07 InnoDB: The InnoDB memory heap is disabled
170114 22:21:07 InnoDB: Mutexes and rw_locks use Windows interlocked functions
170114 22:21:07 InnoDB: Compressed tables use zlib 1.2.3
170114 22:21:07 InnoDB: Initializing buffer pool, size = 38.0M
170114 22:21:07 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 56623104 bytes
InnoDB: than specified in the .cnf file 0 19922944 bytes!
170114 22:21:07 [ERROR] Plugin 'InnoDB' init function returned error.
170114 22:21:07 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170114 22:21:07 [ERROR] Unknown/unsupported storage engine: INNODB
170114 22:21:07 [ERROR] Aborting
170114 22:21:07 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld.exe: Shutdown complete
The old database was 5.5.40 and the new one is 5.5.54, because I've been unable to successfully install the exact same version (the download links that the installer needs no longer work). Is the error simply the size as specified in the .cnf
file or is that masking something else?
Look at this post and look at wombles answer as well as the resolution section in the question: http://serverfault.com/questions/104014/innodb-error-log-file-ib-logfile0-is-of-different-size... hopefully this will fix your issue.
– Pimp Juice IT – 2017-01-14T17:40:58.017