“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...
The command chown set directory user tomysqland group tomysql, which is the proper access rights for the MariaDB daemon. At last, if you want immediately apply the new configuration rules then you must restart the MariaDB server withsystemctl(sudorequired): ...