“1812 Tablespace is missing for table” is a common error in MySQL servers that usually comes up after a server migration, hard disk error, or a new app setup. Today we’ve seen why this error happens and what do here at Bobcares to fix it. Related posts: How to fix MySQL “job f...
二、使用第一步中恢复的DDL语句创建表,并discard tablespace mysql>show databases;+---+|Database|+---+|information_schema||mysql||performance_schema||syk||sys|+---+5rowsinset(0.00sec) mysql>createdatabasereco; Query OK,1row affected (0.00sec) mysql>usereco;Databasechanged mysql>CREATETABLE`t...
If you don't want to include MariaDB error log into syslog, you can set up a custom log file. You can configure custom error log file by editing MariaDB configuration file /etc/mysql/mariadb.conf.d/50-server.cnf (sudo required): $ sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf...