List:General Discussion« Previous MessageNext Message »
From:Gary Josack Date:September 26 2007 3:11am
Subject:Re: Ouch! ibdata files deleted. Why no catastrophe?
View as plain text  
Well if you can stop all instances of writes to the databases you should 
be able to recover them.

Each file is going to be in /proc/5460/fd/10-17

the file number corresponds to the fd you see in lsof output

ex:
cp /proc/5460/fd/10 ibdata2

This is still risky and i reccomend you get a dump immediately. As soon 
as you restart mysql those files are gone forever.

Daniel Kasak wrote:
> On Tue, 2007-09-25 at 19:27 -0400, Gary Josack wrote:
>
>   
>> Did the space become available when deleted?
>>
>> try:
>> lsof | grep deleted
>>
>> see if they're still running in memory. if so you might be able to save 
>> them.
>>     
>
> Thanks for the quick response :)
>
> They're there:
>
> mysqld     5460      mysql   10uW     REG        8,3  1073741824
> 761001 /root/.Trash/ibdata2 (deleted)
> mysqld     5460      mysql   11uW     REG        8,3  1073741824
> 6852461 /root/.Trash/ibdata3 (deleted)
> mysqld     5460      mysql   12uW     REG        8,3  1073741824
> 7376938 /root/.Trash/ibdata4 (deleted)
> mysqld     5460      mysql   13uW     REG        8,3  1073741824
> 6859981 /root/.Trash/ibdata5 (deleted)
> mysqld     5460      mysql   14uW     REG        8,3  1073741824
> 7376491 /root/.Trash/ibdata6 (deleted)
> mysqld     5460      mysql   15uW     REG        8,3  1073741824
> 7376500 /root/.Trash/ibdata7 (deleted)
> mysqld     5460      mysql   16uW     REG        8,3  1073741824
> 1369981 /root/.Trash/ibdata8 (deleted)
> mysqld     5460      mysql   17uW     REG        8,3  1073741824
> 7377058 /root/.Trash/ibdata9 (deleted)
>
> ( sorry about the text wrapping thing )
>
> How do I recover them, and do you think this is wise? At this point, I
> still think it might be a better idea to do a complete reinstall /
> restore / transaction log run.
>
>
> --
> Daniel Kasak
> IT Developer
> NUS Consulting Group
> Level 5, 77 Pacific Highway
> North Sydney, NSW, Australia 2060
> T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
> email: dkasak@stripped
> website: http://www.nusconsulting.com.au
>
>
>   

Thread
Ouch! ibdata files deleted. Why no catastrophe?Daniel Kasak26 Sep
  • Re: Ouch! ibdata files deleted. Why no catastrophe?Gary Josack26 Sep
    • Re: Ouch! ibdata files deleted. Why no catastrophe?Daniel Kasak26 Sep
      • Re: Ouch! ibdata files deleted. Why no catastrophe?Gary Josack26 Sep
        • Re: Ouch! ibdata files deleted. Why no catastrophe?Daniel Kasak26 Sep
          • Re: Ouch! ibdata files deleted. Why no catastrophe?Gary Josack26 Sep
        • Re: Ouch! ibdata files deleted. Why no catastrophe?Baron Schwartz26 Sep
          • Re: Ouch! ibdata files deleted. Why no catastrophe?Ananda Kumar26 Sep
            • Re: Ouch! ibdata files deleted. Why no catastrophe?Baron Schwartz26 Sep
  • Re: Ouch! ibdata files deleted. Why no catastrophe?Martijn Tonies26 Sep
    • RE: Ouch! ibdata files deleted. Why no catastrophe?Jerry Schwartz26 Sep
      • RE: Ouch! ibdata files deleted. Why no catastrophe?Daniel Kasak27 Sep
      • Re: Ouch! ibdata files deleted. Why no catastrophe?Joerg Bruehe28 Sep
  • Re: Ouch! ibdata files deleted. Why no catastrophe?Martijn Tonies27 Sep