topic Re: Is there a way to recover deleted mysql database ? in Operating System - Linux

Is there a way to recover deleted mysql database ?

'chris' — Fri, 02 Jul 2004 07:02:56 GMT

hi

I've deleted (drop) with phpMyAdmin a database
and I didn't do any backups before.
Is there a way to recover deleted mysql database ?

kind regards
chris

Re: Is there a way to recover deleted mysql database ?

Jerome Henry — Fri, 02 Jul 2004 07:52:24 GMT

Check in your /var/lib/mysql dir to see if there still is your database directory... if it's not there anymore, then no hope.
If it's here, check content... maybe phpmyadmin did just erase database name from mysql db table... no auto backup AFA I know...

bad news...

Re: Is there a way to recover deleted mysql database ?

Jan Sladky — Mon, 05 Jul 2004 03:24:48 GMT

hi Chris,

yes, Jerome has right, /var/lib/mysql/nameofdb is the one place only where db and related informations are stored, no online redo logs or control files like at Oracle exist in mysql (so far ;-).

for case of disaster do regular backup of mysql via mysqldump which saved all db intt one file which can be very easily imported after.

see mysqldump --help

good luck, Jan

Re: Is there a way to recover deleted mysql database ?

'chris' — Tue, 06 Jul 2004 17:55:02 GMT

thanks,

but database was lost.

"sh_ _ happens"

greetings
chris

Re: Is there a way to recover deleted mysql database ?

Jan Sladky — Wed, 07 Jul 2004 03:49:39 GMT

Chris,
if you have ext2 filesystem, there is still small chance you can undellete db file, but how time is running chance is smaller and smaller ...

try to find some like undelete ext2, I guess that even Midnight Commander has this feature

good luck

Jan

Re: Is there a way to recover deleted mysql database ?

'chris' — Wed, 07 Jul 2004 09:29:26 GMT

thanks, but it was ext3

Re: Is there a way to recover deleted mysql database ?

Jan Sladky — Wed, 07 Jul 2004 10:58:01 GMT

it sounds bad ...

how did you, or anyone else, get data into mysql ? wasn't used some text file for loading, something like csv ? try to find it

has anyone else made some backup of /var/lib/mysql ?

try to find on entire disk all files with
following sufixes :

trigger.MYD
trigger.MYI
trigger.frm

find / -name '*.MYD'

(It can be in some Trash if were deleted in XManager enviroment)

Jan

Re: Is there a way to recover deleted mysql database ?

'chris' — Thu, 08 Jul 2004 03:46:23 GMT

it was deleted with phpMyAdmin (drop database)