Error 1033 Hy000
Contents |
10.10) had two corrupted tables, with the following errors when we tried to access their content: ERROR 1033 (HY000): /usr/sbin/mysqld: Incorrect information in file: './database/sp_account.frm' ERROR 1033 (HY000): /usr/sbin/mysqld: Incorrect information in general error 1033 incorrect information in file file: './database/sp_screen.frm' Since there were a lot of updates on the database, restoring error code 1033 incorrect information in file a backup was not an option, so we tried the standard recovery tools provided by MySQL: REPAIR TABLE : http://dev.mysql.com/doc/refman/5.1/en/repair-table.html error 1033 hy000 incorrect information in file frm InnoDB recovery : http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html Unfortunately, these two procedures ended up with no successful results 🙁 So we dug more on the Internet, and we found this very interesting article : http://blogs.skysql.com/2011/05/innodb-data-recovery-success-story.html In this article, the authors refers to mysql error 1033 incorrect information file frm the Percona InnoDB Data Recovery Tool which allows recovering lost data by extracting rows from MySQL raw files. We strictly followed the documentation, and finally managed to recover our data in order to restore them in our corrupted tables. Here are the steps that we followed. First, we downloaded the source code of the tool onto our MySQL server; then, we built it (the doc is self explanatory). The next
Mysqldump Got Error 1033 Incorrect Information In File When Using Lock Tables
step consists of extracting the pages using this command: page_parser -5 -f /var/lib/mysql/ibdata1 It creates a directory which contains several subdirectories with a lot of files (in our case "pages-1328713071/FIL_PAGE_INDEX/"). Then, the tricky part is to enable the InnoDB Tablespace Monitor by using this MySQL command: CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; With this monitor enabled, we had to look at the MySQL error log (/var/log/mysql/error.log) in order to locate the page index of our corrupted table: TABLE: name database/sp_account, id 0 85, columns 23, indexes 2, appr.rows 220 ... INDEX: name PRIMARY, id 0 215, fields 1/22, uniq 1, type 3 root page 401, appr.key vals 220, leaf pages 3, size pages 4 ... In this output, it shows that we have to look at the page located in the 0-215 subdirectory of our extracted pages (ie pages-1328713071/FIL_PAGE_INDEX/0-215/). Then, we had to merge the pages files into one: find pages-1328713071/FIL_PAGE_INDEX/0-215/ -type f -name '*.page' | sort -n | xargs cat > merged_file Then, the tool-set needs the definition of the corrupted table. For that, we used the provided Perl script which creates a .h file: ./create_defs.pl --host=localhost --user=XXX --password=YYY --db=database --table=sp_account > include/table_defs.h At this point, we hit a bug, because the "BI
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: MySQL Administrator :: ERROR 1033 (HY000): Incorrect information in file New Topic Advanced Search
Incorrect Information In File Mysql
ERROR 1033 (HY000): Incorrect information in file Posted by: Anuj Goel error 1033 hy000 incorrect information in file mysql tables_priv frm () Date: October 11, 2007 07:52AM Hi All, I recently made some changes in the ini file error 1033 hy000 incorrect information in file mysql proc frm of my MySQL 5.1 server using MySQL Administrator tool. Now when I try to use the tables already there in the database, I get this error message: ERROR https://www.ekito.fr/people/repairing-a-badly-hurt-mysql-database-2/ 1033 (HY000): Incorrect information in file: '.\database\table.frm' I googled it and found some recepies, to change innodb_data_file_path=ibdata1:530M;ibdata2:100M:autoextend The above didnt work for me. Could anyone please point me how to sort this mess? Many thanks. Anuj. Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted ERROR 1033 (HY000): Incorrect information in file Anuj Goel 10/11/2007 07:52AM Re: ERROR http://forums.mysql.com/read.php?34,177212,177212 1033 (HY000): Incorrect information in file Stu Derby 10/28/2007 02:14PM Re: ERROR 1033 (HY000): Incorrect information in file Boyd Hemphill 11/18/2008 10:52AM Re: ERROR 1033 (HY000): Incorrect information in file Mohid Khan 03/19/2009 10:41PM Sorry, you can't reply to this topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads MySQL Community Server MySQL Cluster MySQL Fabric MySQL Utilities MySQL Workbench About MySQL Contact Us How to Buy Partners Job Opportunities Site Map D
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen