search

anyongjin / mysql_ibd

import data from ibd files for mysql
MIT License
30 stars 5 forks source link

pymysql.err.OperationalError: (1812, 'Tablespace is missing for table `demo`.`project`.') #11

Closed itliujia closed 1 year ago

itliujia commented 1 year ago

pymysql.err.OperationalError: (1812, 'Tablespace is missing for table demo.project.')

anyongjin commented 1 year ago

This error seems to be related to the ibd file, indicating that the ibd file cannot be read or accessed properly. For detailed information, you can refer to: https://bobcares.com/blog/mysql-tablespace-is-missing-for-table/

itliujia commented 1 year ago

Thank you very much, I have found the problem, is when the import data, the database data directory does not have.ibd file, manual copy can be used normally.