mysqld: Incorrect information in file

sreeninair

• July 07, 2014 11:14

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

  • August 01, 2014 18:28

  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.

  0

Please sign in to leave a comment.