GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

percona tool recovery tool kit's page parser not working

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • percona tool recovery tool kit's page parser not working

    My data base is corrupt. innodb_force_recovery is not solving the problem as the crash continues. I tried the percona tool kit however the page parser tool is not splitting the pages. It gives the following output

    [root@toywallet2 percona-data-recovery-tool-for-innodb-0.5]# ./page_parser -4 -d -f /var/lib/mysql1/backup/ibdata1
    Opening file: /var/lib/mysql1/backup/ibdata1:
    2049 ID of device containing file
    181116 inode number
    33184 protection
    1 number of hard links
    27 user ID of owner
    27 group ID of owner
    0 device ID (if special file)
    10485760 total size, in bytes
    4096 blocksize for filesystem I/O
    20512 number of blocks allocated
    1350235846 time of last access
    1350232350 time of last modification
    1350232506 time of last status change
    10485760 Size to process in bytes
    104857600 Disk cache size in bytes
    6.16% done. 2012-10-15 04:21:30 ETA(in 00:00 hours). Processing speed: 646310 B/sec
    33.19% done. 2012-10-15 04:21:18 ETA(in 00:00 hours). Processing speed: 2833622 B/sec
    62.68% done. 2012-10-15 04:21:18 ETA(in 00:00 hours). Processing speed: 3092895 B/sec
    92.36% done. 2012-10-15 04:21:18 ETA(in 00:00 hours). Processing speed: 3111622 B/sec

    It doesn't show any error also. What should i do now. Is it a bug of toolkit or my data is corrupted that much.

  • #2
    Hi Rajesh,

    That is old version of script, you should try with newer version from below link.
    https://code.launchpad.net/~percona-dev/percona-data-recover y-tool-for-innodb/trunk

    -d and -4 options are not needed. Can you try to run it without those options?
    i.e ./page_parser -f /var/lib/mysql1/backup/ibdata1

    If its still doesn't work, provide verbose output of that command. Thanks.

    Comment

    Working...
    X