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.
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:
.sprintf(dir_name,"%s/%lu-%lu", dir_name, index_id.high, index_id.low)
.
New
.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.
Hi,
Can you try to recover the data with Percona Data Recovery Tool? Here are some links to get information about it.
[URL]https://launchpad.net/percona-data-recovery-tool-for-innodb[/URL]
[URL]Percona Open Source Software Documentation
[URL]Percona Open Source Software Documentation