slider

can not get page using stream_parser

  1. Backup and Data Recovery for MySQL
  2. can not get page using stream_parser
0
0

I want to recover a drop table but can not get page using stream_parser

table structure
vim recoverd_table_schema/tmp1_schema.sql
CREATE TABLE tmp1(
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(20),
PRIMARY KEY(id)
);

get SYS_TABLES info
./c_parser -4Df pages-ibdata1/FIL_PAGE_INDEX/0000000000000001.page \
-t dictionary/SYS_TABLES.sql | \
grep tmp1

000000004EAB 70000000590F91 SYS_TABLES “test/tmp1” 122 2 1 0 80 “” 112
SET FOREIGN_KEY_CHECKS=0;
LOAD DATA LOCAL INFILE ‘/u02/undrop-for-innodb/dumps/default/SYS_TABLES’ REPLACE INTO TABLE `SYS_TABLES` FIELDS TERMINATED BY ‘\t’ OPTIONALLY ENCLOSED BY ‘”‘ LINES STARTING BY ‘SYS_TABLES\t’ (`NAME`, `ID`, `N_COLS`, `TYPE`, `MIX_ID`, `MIX_LEN`, `CLUSTER_NAME`, `SPACE`);
000000004EAB 70000000590F91 SYS_TABLES “test/tmp1” 122 2 1 0 80 “” 112

get SYS_INDEXES info
./c_parser -4Df pages-ibdata1/FIL_PAGE_INDEX/0000000000000003.page \
-t dictionary/SYS_INDEXES.sql | \
grep 122

SET FOREIGN_KEY_CHECKS=0;
LOAD DATA LOCAL INFILE ‘/u02/undrop-for-innodb/dumps/default/SYS_INDEXES’ REPLACE INTO TABLE `SYS_INDEXES` FIELDS TERMINATED BY ‘\t’ OPTIONALLY ENCLOSED BY ‘”‘ LINES STARTING BY ‘SYS_INDEXES\t’ (`TABLE_ID`, `ID`, `NAME`, `N_FIELDS`, `TYPE`, `SPACE`, `PAGE_NO`);
000000004EAB 70000000590EA6 SYS_INDEXES 122 195 “PRIMARY” 1 3 112 4294967295
000000004EAB 70000000590EA6 SYS_INDEXES 122 195 “PRIMARY” 1 3 112 4294967295

parse disk
./stream_parser -f /dev/sdb -t 20000000k

but not page 195
ll pages-sdb/FIL_PAGE_INDEX/
total 2144896
-rw-r--r-- 1 root root 32768 Sep 9 11:35 0000000000000001.page
-rw-r--r-- 1 root root 81920 Sep 9 11:35 0000000000000002.page
-rw-r--r-- 1 root root 32768 Sep 9 11:35 0000000000000003.page
-rw-r--r-- 1 root root 32768 Sep 9 11:35 0000000000000004.page
-rw-r--r-- 1 root root 32768 Sep 9 11:35 0000000000000005.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000011.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000012.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000013.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000014.page
-rw-r--r-- 1 root root 32768 Sep 9 11:35 0000000000000015.page
-rw-r--r-- 1 root root 32768 Sep 9 11:35 0000000000000016.page
-rw-r--r-- 1 root root 32768 Sep 9 11:35 0000000000000017.page
-rw-r--r-- 1 root root 131072 Sep 9 11:35 0000000000000018.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000019.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000020.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000021.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000022.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000023.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000024.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000025.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000026.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000027.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000028.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000029.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000030.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000031.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000032.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000033.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000034.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000035.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000036.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000037.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000038.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000039.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000040.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000041.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000042.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000043.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000044.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000045.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000046.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000047.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000048.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000049.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000050.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000051.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000052.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000053.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000054.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000055.page
-rw-r--r-- 1 root root 1163264 Sep 9 11:35 0000000000000056.page
-rw-r--r-- 1 root root 507904 Sep 9 11:35 0000000000000057.page
-rw-r--r-- 1 root root 1081344 Sep 9 11:35 0000000000000058.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000059.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000060.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000061.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000062.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000063.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000064.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000065.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000066.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000067.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000068.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000069.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000070.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000071.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000072.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000073.page
-rw-r--r-- 1 root root 65536 Sep 9 11:35 0000000000000074.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000075.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000076.page
-rw-r--r-- 1 root root 32768 Sep 9 11:35 0000000000000077.page
-rw-r--r-- 1 root root 32768 Sep 9 11:35 0000000000000078.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000082.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000083.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000084.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000085.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000086.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000090.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000091.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000092.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000093.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000094.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000095.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000096.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000097.page
-rw-r--r-- 1 root root 81920 Sep 9 11:35 0000000000000098.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000099.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000100.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000101.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000102.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000103.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000104.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000105.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000106.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000107.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000108.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000109.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000110.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000111.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000112.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000113.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000114.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000115.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000116.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000117.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000118.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000119.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000120.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000121.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000122.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000123.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000124.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000125.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000126.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000127.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000128.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000129.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000130.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000131.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000132.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000133.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000134.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000135.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000136.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000137.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000138.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000139.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000140.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000141.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000142.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000143.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000144.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000145.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000146.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000147.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000148.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000149.page
-rw-r--r-- 1 root root 65536 Sep 9 11:35 0000000000000150.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000151.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000152.page
-rw-r--r-- 1 root root 2523136 Sep 9 11:35 0000000000000160.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000161.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000162.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000163.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000164.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000165.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000166.page
-rw-r--r-- 1 root root 49152 Sep 9 11:35 0000000000000175.page
-rw-r--r-- 1 root root 49152 Sep 9 11:35 0000000000000176.page
-rw-r--r-- 1 root root 49152 Sep 9 11:35 0000000000000177.page
-rw-r--r-- 1 root root 49152 Sep 9 11:35 0000000000000178.page
-rw-r--r-- 1 root root 2179973120 Sep 9 11:36 0000000000000179.page
-rw-r--r-- 1 root root 7962624 Sep 9 11:35 0000000000000180.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000000189.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000190.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000191.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000192.page
-rw-r--r-- 1 root root 16384 Sep 9 11:36 0000000000000194.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 0000000000001066.page
-rw-r--r-- 1 root root 16384 Sep 9 11:35 18446744069414584320.page

    • Guest
    • 1 year ago
    Was it just DROP or DROP and CREATE?
  • You must to post comments
Showing 0 results
Your Answer

Please first to submit.