I have a big problem,
I have created a db with these opts in my.cnf:
innodb_buffer_pool_size = 1480MB
innodb_log_file_size = 300M
innodb_log_buffer_size = 4M
innodb_thread_concurrency = 8
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
after that for testing purposes I’ve changed the log_file_size and deleted the ib* files in main mysql dir so they can be recreated upon size change…
but forgot to make mysqldump.
now I have all the innodb tables saying that :
Cannot find table pl/vots from the internal data dictionary of InnoDB though the .frm file for the table exists.
is there any way to rebuild the indexes or dump out the data directly from the bin files, I need the data, so I can reinsert it in a new db if fixing this one is not possible…
Mar 5 16:19:22 temp mysqld: 080305 16:19:22 InnoDB: Error: tablespace id in file ‘./kn_pl/act.ibd’ is 51, but in the InnoDB
Mar 5 16:19:22 templar mysqld: InnoDB: data dictionary it is 86.
if I don’t put:
innodb_force_recovery = 4
or higher than 4 the mysql will give error when trying use kn_pl;
that’s because of names caching (autocompletition) of course but anywayz the tabels are not accessible at all then,
if this option is set, then the tables status says not found for the tables…