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 [at] m.gmane.org
Mark Mchugh [ Mo, 12 September 2005 16:09 ] [ ID #962478 ]

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 [at] 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 [at] m.gmane.org
Brandon Schenz [ Mo, 12 September 2005 16:12 ] [ ID #962479 ]

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 [at] m.gmane.org
Peter Monk [ Mo, 12 September 2005 16:13 ] [ ID #962480 ]

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 [at] 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 [at] 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 [at] ajohnstone.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] m.gmane.org
Andrew [ Mo, 12 September 2005 16:21 ] [ ID #962481 ]

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=

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

HTH.

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

------=_Part_18450_31617721.1126715701111--
yojuice [ Mi, 14 September 2005 18:35 ] [ ID #967936 ]
Datenbanken » gmane.comp.db.mysql.windows » accidently deleted a datase

Vorheriges Thema: Problem with MYsql on Windows
Nächstes Thema: Suspicious Attachment