GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Error then recover data with innodb-tools

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

  • Error then recover data with innodb-tools

    Hi, could you help me. I try to recover data's My SQL with innodb-tools. But then i launch program aften 53% i see error 'can made a directory \0-10675': no space left on device'. How can i change the path, there creating this folders with files?
    Thank you.
    Last edited by karmanovaev; 06-25-2013, 11:50 PM.

  • #2
    Hi,

    Can you please describe which InnoDB-tools you have used to recover the data and how?

    Regards,

    Comment


    • #3
      Originally posted by niljoshi View Post
      Hi,

      Can you please describe which InnoDB-tools you have used to recover the data and how?

      Regards,
      Thank you! We are using InnoDB-tools v.0.5, using this recommendations http://www.chriscalender.com/?p=49.
      Now we soluted this problem:
      we edited 'page_parser.c', changed line:

      Code:
      .sprintf(dir_name,"%s/%lu-%lu", dir_name, index_id.high, index_id.low)
      .
      New
      Code:
      .sprintf(dir_name,"/var/temp_db/%s/%lu-%lu", dir_name, index_id.high, index_id.low)
      .

      Now we have another problem . After then we divide the main file to many pages (*.page), we begin to verificar files that named .page, and then writing similar numbers (attach.) But we can see data in 'ibdata1' partly. And 'table_defs.h' have not problem. Also we found, that folder with index files empty.
      We tried to recover another DB table but see same problem.

      Thank you.

      Comment


      • #4
        Hi,

        Can you try to recover the data with Percona Data Recovery Tool? Here are some links to get information about it.

        https://launchpad.net/percona-data-r...ool-for-innodb
        http://www.percona.com/docs/wiki/inn...ery-tool:start
        http://www.percona.com/docs/wiki/inn...recovery:start

        Comment

        Working...
        X