Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
March 8, 2006, 8:07 am
rate this thread
logged into my server an hour ago just to find that the root partition
is 100% filled:
34285296 32544556 0 100% /
Because of that (I think), the data directory associated with my MySQL
installation got shot (read: disappeared!).
What would be the best way to recover the mysql data? The MySQL daemon
isn't running, and I can't find anything under lost+found, either!
Please help for I *really* need to get [some or most of] the data back!
Re: SOS! Root filled, want to recover MySQL data!
That would be very surprising. If the directory was removed, then wouldn't
that have freed up some space on the filesystem?
Are you absolutely certain you're looking in the right place for the data
directory? That is, have you confirmed by querying the MySQL instance that
it's using that location as the data directory, or are you assuming?
Is it possible your MySQL data dir was on a separate filesystem, and it
isn't currently mounted?
This demonstrates the value of making database backups and storing the
backups on a different server.
If the files have really been deleted, and the filesystem is 100% full, it's
likely that the physical tracks on the disk have been overwritten with other
data. If that's the case, there's probably no possibility of using one of
the "undelete" tools that are available for some operating systems.
By the way, you don't mention what operating system you're using, its
version, and the filesystem type of /root.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum