mysqld: Incorrect information in file

sreeninair

Well-Known Member
Dec 23, 2013
100
0
16
cPanel Access Level
Root Administrator
Hello,

I am getting this error in my mysql log file.

=================
140707 10:46:20 [ERROR] mysqld: Incorrect information in file: './lindseya_drupal_Old/field_data_field_email.frm'
140707 10:46:20 [ERROR] mysqld: Incorrect information in file: './lindseya_drupal_Old/themekey_ui_author_theme.frm'
140707 10:46:37 [ERROR] mysqld: Incorrect information in file: './lindseya_drupal_Old/field_data_field_email.frm'
140707 10:46:37 [ERROR] mysqld: Incorrect information in file: './lindseya_drupal_Old/themekey_ui_author_theme.frm'
=================

This is not a database, its just a backup of database 'lindseya_drupal'. My question is what will be the impact of saving backups of database in data directory of mysql itself.

Thanks
Sreeni
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,215
363
Hello :)

You should move that directory to a location outside of the MySQL data directory. Otherwise, it's going to result in warnings and conflicts like what's listed in your MySQL error log. Note that "mysqldump" is a useful utility for backing up a database, as opposed to simply copying the database directory.

Thank you.