Symptoms
When accessing a table in phpMyAdmin, you receive the following error.
1286 - Unknown storage engine 'InnoDB'
You will also see entries similar to the following in the MySQL/MariaDB error log.
2022-03-12 15:43:40 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'InnoDB'". Some plugins may be not loaded 2022-03-12 15:43:40 0 [ERROR] Can't open and lock privilege tables: Unknown storage engine 'InnoDB'
Description
The issue commonly occurs when the InnoDB logfiles have become corrupt. Moving the files out of the data directory will force the files to be rebuilt.
Workaround
- Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
- Create a storage directory for the files.
mkdir /root/innodb.bak
- Stop the SQL service.
/usr/local/cpanel/scripts/restartsrv_mysql --stop
- Move the log files to the storage directory.
mv -v /var/lib/mysql/ib_logfile* /root/innodb.bak/
- Start the SQL service.
/usr/local/cpanel/scripts/restartsrv_mysql --start
Comments
0 comments
Article is closed for comments.