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
>
>
>
