accidently deleted a datase

Hi,
Disaster, through php admin, i accidently deleted a
database, is there anyway to get it back?


thanks :(

MArk




______________________________________________________
Yahoo! for Good
Donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: accidently deleted a datase

Only by restoring it from a back-up.

*Brandon Schenz*
Midwest Sports Supply
IT Manager
Phone: 513-956-4900
Fax: 513-956-4910
E-mail: brandons@midwestsports.com


Mark Mchugh wrote:

>Hi,
>Disaster, through php admin, i accidently deleted a
>database, is there anyway to get it back?
>
>
>thanks :(
>
>MArk
>
>
>
>
>______________________________________________________
>Yahoo! for Good
>Donate to the Hurricane Katrina relief effort.
>http://store.yahoo.com/redcross-donate3/
>
>
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: accidently deleted a datase

Mark Mchugh wrote:

> Disaster, through php admin, i accidently deleted a
> database, is there anyway to get it back?

Don't know about any MySQL method, but as MySQL tables are
stored as files on disk, perhaps try a file system based
undelete or data recovery tool.

Peter.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: accidentally deleted a dataset

I'm not sure if you can restore an entire database, however you can recover
data through the binary logs...

http://dev.mysql.com/doc/mysql/en/binary-log.html

You should really periodically backup the data...

Anyway hope that helps..

Best Regards,

Andrew



-----Original Message-----
From: Brandon Schenz [mailto:brandons@midwestsports.com]
Sent: 12 September 2005 15:12
To: Mark Mchugh
Cc: mysql list
Subject: Re: accidently deleted a datase


Only by restoring it from a back-up.

*Brandon Schenz*
Midwest Sports Supply
IT Manager
Phone: 513-956-4900
Fax: 513-956-4910
E-mail: brandons@midwestsports.com


Mark Mchugh wrote:

>Hi,
>Disaster, through php admin, i accidently deleted a
>database, is there anyway to get it back?
>
>
>thanks :(
>
>MArk
>
>
>
>
>______________________________________________________
>Yahoo! for Good
>Donate to the Hurricane Katrina relief effort.
>http://store.yahoo.com/redcross-donate3/
>
>
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=andrew@ajohnstone.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: accidently deleted a datase

------=_Part_18450_31617721.1126715701111
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi, Mark -

There's certainly no way in MySQL or in phpmyadmin.

In MySQL, each database is a subdirectory in the \MySQL\data\ directory and=
=20
each table (and associated files) is a file inside the database's=20
subdirectory, so you might try an undelete or unerase utility to see whethe=
r=20
you can get it back directly.=20

HTH.

virginia
--=20
\ / Virginia R. Hetrick, here in sunny California
0 Voicemail: 310.471.1766 Email: drjuice@gte.net
Oo "There is always hope."
Keeping track of the weather:=20
http://www.washington.edu/cambots/camera1_l.gif

------=_Part_18450_31617721.1126715701111--