Professional custom made chair manufacturer focus on chair & stool furniture development and production for more than 20 years.

MySQL Server database stores data dictionary information

by:Modern Century     2021-03-20

The out-of-sync data dictionary situation can be indicated by various symptoms. One symptom of this problem is that the 'Create Table' statement does not work. When this situation occurs, you should check the error log of server. If the error log indicates that table already exists in InnoDB internal data dictionary, there is an orphaned table in InnoDB tablespace files, which does not have corresponding .frm file.

You are allowed to drop orphaned table, using the steps given in error message. If you are unable to run 'Drop Table' command successfully, the issue may be caused by name completion in MySQL client. To sort out this issue, start MySQL client with -skip-auto-rehash option and try using Drop Table command.

Another symptom of the out-of-sync issue with data dictionary is the error message that MySQL gives when you try to open a database table:

'ERROR 1016: Can't open file: 'child2.InnoDB'. (errno: 1.'

In error log of MySQL, you may find the below message:

'InnoDB: Cannot find table test/child2 from the internal data dictionary

InnoDB: of InnoDB though the .frm file for the table exists. Maybe you

InnoDB: have deleted and recreated InnoDB data files but have forgotten

InnoDB: to delete the corresponding .frm files of InnoDB tables?'

This behavior of MySQL database indicates corruption to the database tables and you need to restore them from backup to Repair MySQL Database.

In the else case, you can use third-party MySQL Repair software. These applications are able to repair and restore damaged MySQL database table in original state, without altering original data and structure. The absolutely Recover MySQL database through high-end scanning techniques, with all of the database objects.

MySQL is a powerful application to restore all of the MySQL database objects such as table, tablespace, queries, report, form, view, and more. The software is designed for MySQL 5.x and 4.x. It works well with both InnoDB and MyISAM storage engines of MySQL.

Custom message
Chat Online 编辑模式下无法使用
Chat Online inputting...
Thank you for your enquiry. We will get back to you ASAP