# 1033 - Incorrect information in the file: './database_name/table_name.frm'

Question

I completely lost my idea of ​​how and why this error is displayed when I go to the table data view.

The only thing I noticed was that the Storage Engine was switched to MyISAM with InnoDB, saying that it was disabled.

I am waiting to hear from the hosting company, but is there anything that I can research until I hear from them?

sql should be copied to the server, but when I upload it, the file is empty.

Any advice on accessing this data is greatly appreciated.

Answer 1

It looks like your host might disable InnoDB, which will render any existing InnoDB tables unusable. They may also have accidentally destroyed the InnoDB data file.

In any case, you cannot do anything to restore it.

Answer 2

Go to /etc/my.cnf change configuration in

max_connections = 2500 query_cache_limit = 2M query_cache_size = 150M tmp_table_size = 200M max_heap_table_size = 300M key_buffer_size = 300M tmpdir = /dev/shm 

Start command: restart mysqld service

Check again, Good luck.

Answer 3

Just try restarting mysql. This helped me solve the problem.