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: [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]
