I am doing the restoration of a corrupted BD, that is, I can not perform consultations, modifiations, updates, etc. Check the following error:
Error 1146 (42S502): Table 'nombre_tabla' doesn't exist .
Due to this error I can not perform recovery processes like opimize table "nombre_tabla" , alter table "nombre_tabla" engine=innodb (These are the ones I have tried to implement and some of the ones I see the most on the web).
Knowing this, I decided to implement the method of innodb_force_recovery = n , where n is a number from 1 to 6. This line is placed in a configuration file of mysql that is located in the folder etc / mysql / mysql.conf. d / mysqld.cnf
Once adding this line I can implement the mysqlcheck --check "database" --user=root --password="contrasena" command.
This command allows to visualize if the tables have some fault or if they are corrupt.
This is where the interesting thing begins, since in this part I can visualize the tables that are corrupted. All of them make me the following error:
InnoDB: The B-tree of index "PRIMARY" is corrupted
error: Corrupt .
How can I resolve my error? I hope and have correctly explained the problem, thank you very much:)