Our MySQL8 database crashed due to lack of free space in the data directory. After we organized more space, the database kept crashing with the error
I know that there are a lot of things with this kind of problem. Believe me, I've tried everything, otherwise I would not have opened this one.
I was able to start it only with recovery mode 6, but after that, it still does not start without the recovery mode. After searching the internet, I tried many solutions but nothing worked.
At this point, I have stopped trying to recover the database and I have created a new database with the same file my.cnf in the hope of. import data from IBD files. I only changed the data directory from my.cnf file. The data directory of the blocked database was "/ var / lib / mysql / sas /" the new database has "/ var / lib / mysql / sas / data / data /", which allows me to move immediately the IBD files. I can not empty tables and import them into the new database because they are too big and too many. It would take at least a month.
What I did was;
create a table on the new database delete table space and move the IBD file to the new database data directory import table space
The page offset does not match the file offset: page offset: 262144, file offset: 262144
I can select the same table in the open overwritten database with recovery mode 6. So I do not think the IBD file is corrupted. Here I came out of ideas.
I am totally desperate at this point and any help would be welcome. Thank you