mysql_ibd
mysql_ibd copied to clipboard
anyongjin
import data from ibd files for mysql
执行load_data 的时候出现下面的错误，请问要怎么解决？ pymysql.err.OperationalError: (1808, 'Schema mismatch (CFG file is missing and source table is found to have row versions. CFG file is must to IMPORT tables with row versions.)')
Schema mismatch的问题我试了几种方法都不太行，后来猜测是tosql生成的建表sql代码有问题，于是我找来了原始的CREATE TABLE语句，用原始的CREATE TABLE语句建表。 建表之后再load_data(我没有试过，因为担心导出的sdi文件会和原始的CREATE TABLE不匹配)，或者直接手动操作： **1.删除原tablespace 2.复制ibd文件 3.重新建立tablespace** 这样处理就不会出现scheme mismatch的问题啦！ 事后来看这件事情，上面的操作说明scheme mismatch的一种情况是出在表结构上的，有可能.ibd文件没有包含原始table的全部表结构信息，或者存在歧义。那么当没有原始的CREATE TABLE语句时，能否仅调整tosql的结果，也就是.sql文件来达到目的呢？我后面只尝试了一次，确实也解决了scheme mismatch的问题： 我比较了原始CREATE TABLE语句和.sql中语句的差别，发现主要的区别出现在CREATE TABLE的末尾，一般是定义主键和索引的语句上。我把tosql生成的.sql文件中定义INDEX的语句改成定义KEY： ``` mysql KEY `F_PRT_ENDDATE` (`F_PRT_ENDDATE`), KEY `S_INFO_WINDCODE` (`S_INFO_WINDCODE`) USING BTREE, KEY `S_INFO_STOCKWINDCODE`...
``` 唯一索引 CREATE TABLE `student` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'xx', `teacher_id` int DEFAULT NULL COMMENT 'xx', `name` varchar(20) NOT NULL COMMENT 'xx', `sex` varchar(10) DEFAULT 'male' COMMENT...
My linux web server of wordpress is dead by accident in unknown reason. MySQL 8.2 is not able to service on and error log is not able to easily understand...
whereis on Linux works like this: ``` whereis ibd2sdi ibd2sdi: /usr/bin/ibd2sdi /usr/share/man/man1/ibd2sdi.1.gz ``` so the script crashes with: ``` Traceback (most recent call last): File "sdi2sql.py", line 182, in ibd2sql(config)...
Hi, thank you for your work. Unfortunately, we encountered the schema mismatch error that you addressed in your related questions section. Comparing the two sdi files, there seem to be...
Hi I tried to recover some tables using the .ibd files. I recovered most of them. I found that some of them did not work. Comparing the table structure to...
Hi! I had 3 databases accidentally deleted on my server. And the Backup is corrupted! Faced with the fact, I managed to recover the *.ibd files from the server However,...
