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…