… an option: Table was dropped and innodb_file_per_table is ON Frm file corrupt, zeroed out, lost or SHOW CREATE TABLE crashes MySQL There is yet another source of information about the table structure – InnoDB dictionary. Let’s review tables from… exist for any InnoDB table. If explicitely defined its `NAME` is PRIMARY. If the primary key is not defined InnoDB will use a…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… it will still replicate in case DROP TABLE statement is used on a temporary table. Bug fixed #1084702 (Seppo Jaakola). In case… excluding lost+found folder if found. Bug fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access… username and password) would be lost. Bug fixed #1158443 (Raghavendra D Prabhu). In case CREATE TABLE AS SELECT statement was running in…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been deprecated. Feature has… mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would be lost. Bug fixed #989253 (Alexey…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been deprecated. Feature has… mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would be lost. Bug fixed #989253 (Alexey…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
…. Bugs fixed #1031427 and #1051874. When mysqldump was used with –innodb-optimize-keys option it produced invalid SQL for cases when… mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would be lost. Bug fixed #989253. Percona… missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981. Other bugs fixes: bug fixed…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…Innodb tables): mysql> optimize table test; +———–+———-+———-+———————————-+ | Table…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
… how data was lost: MySQL had a dedicated partition on XFS file system Server was running innodb_file_per_table There was a… and dropped their copy of the data The important tables were all InnoDB Having a backup, customer has first attempted to restore… was scanned in like 5 minutes and all 4G of innodb pages were successfully written to a separate partition. That’s…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
… and they lost the ibdata1 file, where all the table meta-data is stored. Fortunately, they were running with innodb_file_per_table so… MyISAM table Advance the Innodb tablespace id by creating fake Innodb tables Once the Innodb tablespace id is minus one of a customer table alter the table…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
…table test_innodb; +————-+—————————————————————————————————————————-+ | Table | Create Table…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…related with tables and indexes (with their IDs) to the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name employees…has recovered his salary again 
Conclusion With InnoDB the deleted rows are not lost. You can recover them from the original …
