Database Corruption With Mariadb:Table Doesn't Exist in Engine

Database corruption with MariaDB : Table doesn't exist in engine

Something has deleted your ibdata1 file where InnoDB keeps the dictionary. Definitely it's not MySQL who does

MariaDB crash: Table doesn't exist in engine && can't recover tables

In the end I wasn't able to recover the above server. I tried disabling one site at a time to prevent DB-access of the corrupted tables. In the end one DB contained the issue and by disabling the site mariadb didn't crash anymore.

To be sure I extracted the database data and started over on a new server. That was about 5 hours of work but after that I'm confident in my setup once again.

I've started work on restoring an old backup of the corrupted data, I've also switched back from MariaDB to Mysql as I suspect MariaDB of being the culprit.

So backups saved my day here...

Oracle Sql: Extracting Text Between Two Characters

How to Split a Row in Multiple Rows SQL Server

Sql Select Everything After a Certain Character

Multiple Query Same Table But in Different Columns MySQL

Use Current Date as Default Value for a Column

Error 1067 (42000): Invalid Default Value for 'Created_At'

Select Query to Remove Non-Numeric Characters

Error Code 1292 Incorrect Date Value MySQL

Datediff Getting the Previous Month

Mysql - Left Join Takes Too Long, How to Optimize Query

Find Records from One Table Which Don't Exist in Another