Page 1 of 1
data recovery in linux?
Posted: Mon Jul 09, 2007 7:14 pm
by potato
Hi,
after a server-down strugle of almost 13 hours, are there mysql-db's that are missing.
I searched with shell locate, nothing everything gone.
There is one db that has a big value of importance and money, so i really want to get this one back.
I know in windows and mac there are some apps where i can recover lost data.
Is there such a solution for linux?
We are using fedora6, and only root shell access, so no graphical interface.
The server is production server with many clients running accounts.
Tomorrow we will reinstall the whole server so whole new fedora, so i think if theres a solution, it has to be
recovered now before everyhing is overwritten again and lost forever.
So i have short time to do it.
PLEASE HELP ME
greets,
tom
Posted: Mon Jul 09, 2007 11:43 pm
by potato
i see that there's not much response to this problem.
I just found a site that sells software to recover data on linux.
Looks promising, but it would be better if i find a shell script for this.
And one that doesn't need the hd to be removed, so that the script recovers from a hd on the server itself.
Anyway, for if someone needs the same later, this is the url:
http://www.unistal.com/quick_recovery_LINUX.html
Posted: Mon Jul 09, 2007 11:46 pm
by Benjamin
Your database files on Fedora 6 are in /var/lib/mysql/
Are you saying they are missing? That means they were either deleted, the hardrive is failing, or you got hacked.
Posted: Mon Jul 09, 2007 11:54 pm
by potato
thanx for your answer.
We had a directadmin - suphp conflict, where the whole server went down.
When reinstalling da, and the server whas up again, all the db's and emailaccounts where gone.
Its very strange, because the account of our hostingcompany whas the only that where affected.
All the other accounts are untouched.
If it whas hacked, is there a good way to check this?
How can someone delete all the db's and mailaccounts?
Posted: Tue Jul 10, 2007 12:07 am
by themurph
Well if directadmin is anything like plesk, it stores account info and database tables in it's own directories, not the system default locations. If you re-installed DA, it may very well have wiped everything out and started everything from scratch.
Plesk ships with it's own backup utility, which has saved my behind many times over the past few years. Does DA have a backup utility? If so, and you made use of it, you may be able to at least partially recover accounts, tables, etc.
Check the documentation and the DA forums.
Posted: Tue Jul 10, 2007 12:41 am
by potato
yes, directadmin somethin like plesk and cpanel.
It has a backup function (still in beta), but the latest backup whas from a month ago.
So we can partially recover the lost db's, but our latest db, that took me much time and money to have configured right, isnt in the backup.
And we where almost finished with this db to go online.
In workhours, its about 100 a 150 hours spend on this db, so it would be a really pain in the **s if this one is lost.
another thing: the future release of mac os x will have 'time machine' build in the os.
With this, you can easely recover deleted files with a few clicks, they maked it less obscure.
Someone knows a linux distribution that has more or less the same function, so a filerecovery function build in the os.
Posted: Tue Jul 10, 2007 12:46 am
by themurph
That's what this project aims to implement:
https://launchpad.net/timevault/+download
It's still alpha, but something to keep an eye on.
TimeVault Lifehacker writeup:
http://lifehacker.com/software/featured ... 275399.php
TimeVault ubuntu forum thread:
http://ubuntuforums.org/showthread.php?t=474973