I am running MySQL (5.7) on a Windows 2012 server. One of the table (> 1 million records) seems to be corrupted. The mysql error log shows
2019-01-16T09:41:09.256990Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190116 14:41:09 2019-01-16T09:41:25.153201Z 2 [Warning] IP address 'ip' could not be resolved: No such host is known. 2019-01-16T09:41:25.620502Z 3 [ERROR] InnoDB: Trying to access page number 3 in space 470, space name shop/products, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. 2019-01-16T09:41:25.623268Z 3 [ERROR] InnoDB: Server exits.
This issue raised when I was inserting records in this table. This table have 22 indexed columns and one of them is FULLTEXT.
I have also tried innodb_force_recovery = [1 - 6], but I am not able to dump the products table. Whenever I tried to access this table it crashes the DB server.
is there any way to get dump or recover this table. I have old dated backup so I can't use that one. Thanks :)
MYSQL Server Details:
Version 5.7 (32 bit)
Windows Server 2012
Database Engine: InnoDB
I am facing the strange issue. When I execute the table status command it shows the rows count is zero,
but products.ibd file size is 4GB in mysql data folder.
SHOW TABLE STATUS FROM shop LIKE 'products';
File size by OS