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: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to