Jump to content


Photo

Incorrect Information in File == MySQL Table Corrupted?


Best Answer connorwood, 28 July 2015 - 06:17 AM

Shutting Down and Restoring a Database

mysqladmin --defaults-file=/usr/local/mysql/my.cnf --user=root --password shutdown

mysqlbackup --defaults-file=/usr/local/mysql/my.cnf \

  --backup-dir=/export/backups/full \

    copy-back

Note

The restored data includes the backup_history table, where MySQL Enterprise Backup records details of each backup. Restoring this table to its earlier state removes information about any subsequent backups that you did. This is the correct starting point for future incremental backups, particularly those using the --incremental-base option.

Important

Before restoring a partial backup, you might need to delete first from the backup the .frm files associated with InnoDB tables that were not backed up.

 

Read and learn following resource where the same issue was solved…

 

http://www.filerepai...ecame-corrupted

https://social.msdn....m=sqldataaccess

https://www.repairto...ysqlrepair.html Repair Toolbox for MySQL

Go to the full post


  • Please log in to reply
4 replies to this topic

#1 vargaetele

vargaetele

    Serf

  • Lurker
  • 1 posts

Posted 27 July 2015 - 04:58 AM

Hi Experts,

 

I encountered the following problem when I'm trying to open SOME tables in MySQL database:

"Incorrect information in file ./[database name]/[table name].frm"

 

Other tables within the same database can be opened without any issues, only some tables have this problem. And this is not just happening in one database, but the other database on the same server also has this problem (there are 2 databases AFAIK on this server). Not sure if anyone else is using this server. The database is InnoDB, running on Win2k3. Are there any other information that is required that I didn't provide?

 

I have read through posts in mysql forum and it seems like none of them is able to solve my problem. The database used to work since being deployed 2 years ago and the last time the my.ini is amended is 2 years ago.

 

It sounded like a data corruption issue to me and the only way is to perform data restoration from the last known working state. However, is there something wrong somewhere that I can check and fix without needing to do a restoration of the database? The users are dead against it as it would mean loss of data since the date of restoration.

 

Thanks!



#2 connorwood

connorwood

    Serf

  • Lurker
  • 1 posts

Posted 28 July 2015 - 06:17 AM   Best Answer

Shutting Down and Restoring a Database

mysqladmin --defaults-file=/usr/local/mysql/my.cnf --user=root --password shutdown

mysqlbackup --defaults-file=/usr/local/mysql/my.cnf \

  --backup-dir=/export/backups/full \

    copy-back

Note

The restored data includes the backup_history table, where MySQL Enterprise Backup records details of each backup. Restoring this table to its earlier state removes information about any subsequent backups that you did. This is the correct starting point for future incremental backups, particularly those using the --incremental-base option.

Important

Before restoring a partial backup, you might need to delete first from the backup the .frm files associated with InnoDB tables that were not backed up.

 

Read and learn following resource where the same issue was solved…

 

http://www.filerepai...ecame-corrupted

https://social.msdn....m=sqldataaccess

https://www.repairto...ysqlrepair.html Repair Toolbox for MySQL



#3 henryrice

henryrice

    Serf

  • Lurker
  • 2 posts

Posted 24 September 2015 - 05:15 PM

Hello...

 

Nice answer...good luck..


Edited by henryrice, 20 January 2017 - 09:02 PM.


#4 henryrice

henryrice

    Serf

  • Lurker
  • 2 posts

Posted 20 January 2017 - 09:02 PM

Hi,

Data corruption is just like nightmare. It is the worst experience for the DBA’s when they find their important data inaccessible. Lots of reasons are there to get your file to corrupt. However ways are also available to repair the corrupt mysql table. I would like to share with you of how to repair a corrupt mysql table when it gets corrupt. Just have a look on the below mentioned link and you will be able to know about how the fix the corruption issue.

 

http://mysql.filerep...upt-mysql-table



#5 Rybags

Rybags

    Immortal

  • Super Hero
  • 35,058 posts

Posted 20 January 2017 - 09:20 PM

Wrong, wrong, wrong!

 

The proper tool to use is here:

 

http://spammalwarein...m/pleaseshaftme






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users