After nearly every recovery case the same question arises: How many MySQL records were recovered and how many were lost. Until now… one page no records will be found in the root page. For the root page it will print “Leaf page: NO” and…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… the latest revision of the recovery tool bzr branch lp:percona-data-recovery-tool-for-innodb 1. … tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/… statement for a table: ./sys_parser -u root sakila/actor CREATE TABLE `actor`( `actor_id` …
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
… – and redo logs – ib_logfile*. MySQL keeps InnoDB files open all the time. The following recovery technique is based on this fact… owner: root@localhost:/var/lib/mysql# chown -R mysql ib* root@localhost:/var/lib/mysql# And restart MySQL: root@localhost:/var/lib/mysql# /etc/init.d/mysql restart After…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… to install the tools in /root/recovery-tool folder and the data like tablespaces and recovered rows in /root/recovery-tool/data. After the… is to import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data/salaries.recovery‘ REPLACE INTO TABLE `salaries` FIELDS TERMINATED…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
… all this in place, recovery the data was just another Bash script: #!/bin/bash CURRENT_ID=1 mysql -u root “create database if….ibd /var/lib/mysql/recover/ chown mysql.mysql /var/lib/mysql/recover/$CURRENT_TABLENAME.ibd sleep 1 echo “importing tablespace” mysql -u root -e “alter table…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… from a snapshot (and binary logs for point in time recovery) in case of that ‘Oops’ moment? Let me show you… –stop-position 336797133 mysql-bin.000022 | mysql [root@sb logs]# mysqlbinlog –verbose –base64-output=decode-rows –start-position 336797275 mysql-bin.000022 | mysql mysql> select count…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… need to copy files. Fast Recovery Recovery time is as fast as putting data back and standard MySQL crash recovery, and it can be… to have snapshot campatibility – this is obvious one. May need root access In some organizations DBA and System Administrator are different… read-write snapshot is you can actually start MySQL Server on it and perform recovery, check tables or do whatever else you…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…_outdated_slaves=”false” \ binary=”/usr/bin/mysqld_safe” test_user=”root” \ test_passwd=”rootpass” \ op monitor interval=”5s” role=”Master” OCF… otherwise Pacemaker will stop MySQL on a slave that lags behind. This will absolutely not help its recovery. test_user and test_passwd: The credentials to test MySQL. Default is to run select count(*) on mysql.user table…
Post: Concatenating MyISAM files
November 19, 2012 By 5 Comments
….MYI root@django:/var/lib/mysql/test# root@django:/var/lib/mysql/test# cat test_concat_part.MYD >> test_concat.MYD root@django:/var/lib/mysql… affected (0.00 sec) mysql> flush tables; Query OK, 0 rows affected (0.00 sec) root@django:/var/lib/mysql/test# myisamchk -rq…: Couldn’t fix table with quick recovery: Found wrong number of deleted records myisamchk: error: Run recovery again without -q MyISAM-table…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
… pages-1345219305/FIL_PAGE_INDEX/0-1 LOAD DATA INFILE ‘/root/src/recovery-tool/s_tools/dumps/default/SYS_INDEXES’ REPLACE INTO…/lib/mysql/ibdata1 # ./bin/constraints_parser.SYS_TABLES -4Df pages-1345220873/FIL_PAGE_INDEX/0-1 LOAD DATA INFILE ‘/root/src/recovery-tool…/lib/mysql/ib_logfile1 sakila/actor sakila/actor 15 # ./s_indexes /var/lib/mysql/ib_logfile1 15 0-18 0-19 Now recovery…
