I am having some difficulty with my MySQL database.
It appears the server suffered from a power outage during the night. As a result, MySQL wouldn't start when it reboots.
I viewed the error log and saw:
[ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 322393393 and the end 322394369.
[ERROR] InnoDB: Plugin initialization aborted with error Generic error
[ERROR] Plugin 'InnoDB' init function returned er
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Failed to initialize builtin plugins.
MySql will only start with
At this point I am trying to save the data by running from MySQL Workbench:
mysqldump.exe --defaults-file=#### --user=#### --host=localhost --protocol=tcp --port=59452 --default-character-set=utf8 --single-transaction=TRUE --skip-triggers "BusinessManager"
Workbench shows me this error:
mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'BusinessManager' AND TABLE_NAME = 'Activities';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)
Operation failed with exitcode 2
However, the MySQL log shows:
[ERROR] InnoDB: Failed to find tablespace for table
Activitiesin the cache. Attempting to load the tablespace with space id 195
The log error is repeated for each table and the SQL dump fails.
Is there any way to save the data in the database and bypass these errors?