… of your tables. In this particular scenario is faster to recover single tables than a full backup. This is easy with… time and some headaches 
Instead of recovering all the InnoDB data we are going to recover only the “salaries” table: Discard the… is back again! Conclusion: As we learned , you can also recover single InnoDB table as with MyISAM but knowing in advance…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
… have .frm file for the table and you need to recover CREATE TABLE statement for this table. In particular when we… no schema changes in between. So how to recover CREATE TABLE from .frm file ? Recovering from .frm for Innodb Table If we…; ERROR 2013 (HY000): Lost connection to MySQL server during query Recovering CREATE TABLE from .frm file for MyISAM Table We do…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… you better to understand how Innodb recovery works. When Innodb recovers from logs it finds the last checkpoint time. Innodb has… will be in the end thus larger database tend to recover longer. Buffer Pool Size This affects recovery time from two… how do you estimate how long it takes Innodb to Recover ? Now you know there are multiple of variables which all…
Post: Recovering from a bad UPDATE statement
October 19, 2012 By 5 Comments
… know that in MySQL 5.5 that sometimes you can recover from a bad UPDATE statement? This is possible if you… one row changed — you don’t need anything fancy to recover from this failure case and can just run another UPDATE…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
… because of client lacking the proper backup or sometimes because recovering RAID might improve recovery, for example you might get point… you can get root login via SSH it can be recovered as any generic Linux server. When you restart the system…
Post: Recover BLOB fields
July 1, 2010 By 4 Comments
… tests. The complexity of BLOB fields brings prerequisites to successfully recover a record with BLOB : all pieces of the BLOB field…_EXTERN_LEN must not be corrupted. The tool outputs the recovered table in tab-separated values format. BLOBs are printed in…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… like Innodb corruption or soft crash which you can’t recover promptly enough. In this case most typically you would plan… master with few slaves) are much easier to deal with. Recovering the data with replication you always have to keep replication positions in mind. Such if you recover master you need to recover slaves to matching snapshot – either it has to…
Post: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
… 100% recovered if they were not overwritten yet, as well as recover dropped Innodb tables. We also can get some data recovered from… request because neither MySQL nor Oracle could help them to recover the date so we had to get our hands dirty… release code for our innodb recovery toolset, so you can recover your data for free if you’re ready to spend…
Comment: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
…, you can modify the grastate.dat directly to match your recovered sequence number directly and just restart mysql via your init… out where it left off using –wsrep-recover: [root@node3 ~]# mysqld_safe –wsrep-recover 130131 12:44:17 mysqld_safe Logging to… to `nohup.out’ 130131 12:44:23 mysqld_safe WSREP: Recovered position 8d211006-5bf5-11e2-0800-067f71542765:314773 130131 12:44…
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
… access this information by calling mysqld with option: mysqld –wsrep-recover and having this information, we can force the node to… case. As it all may sound complicated, this logic –wsrep-recover / –wsrep_start_position= is implemented in mysqld_safe script, so…-0800-930817fe924a:8549230 130129 23:01:45 mysqld_safe WSREP: Recovered position 50176f05-69b5-11e2-0800-930817fe924a:8549230 130129 23:01…
