List:General Discussion« Previous MessageNext Message »
From:Daniel Kasak Date:September 25 2007 11:54pm
Subject:Re: Ouch! ibdata files deleted. Why no catastrophe?
View as plain text  
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