Re: Recover dropped database

2012-10-29 Thread Lorenzo Milesi
That's rough. The only thing I could suggest is try out Percona's data recovery tool My collegue did some recovery using Percona tools and (suspance...) recovered 95% of the data! Lovely! Ciao. maxxer -- Lorenzo Milesi - lorenzo.mil...@yetopen.it GPG/PGP Key-Id: 0xE704E230 -

Re: Recover dropped database

2012-10-29 Thread Sharl Jimh Tsin
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 于 2012年10月29日 17:18, Lorenzo Milesi 写道: That's rough. The only thing I could suggest is try out Percona's data recovery tool My collegue did some recovery using Percona tools and (suspance...) recovered 95% of the data! Lovely! Ciao.

Re: Recover dropped database

2012-10-29 Thread spameden
Hi, could your collegue please share steps he taken to recover data? I'd be interested most definetely! Thanks 2012/10/29 Lorenzo Milesi max...@ufficyo.com That's rough. The only thing I could suggest is try out Percona's data recovery tool My collegue did some recovery using Percona

Recover dropped database

2012-10-26 Thread Lorenzo Milesi
Hi. Dramatic situation: unwanted database drop. Obviously I don't have a dump, because of other issues... Question: is it possible to recover something? Storage is innodb, no separate files for tables, everything is in ibdata1. I started recovering .frm files using ext3grep, but the problem is

Re: Recover dropped database

2012-10-26 Thread Reindl Harald
Am 26.10.2012 15:33, schrieb Lorenzo Milesi: Hi. Dramatic situation: unwanted database drop. Obviously I don't have a dump, because of other issues... Question: is it possible to recover something? Storage is innodb, no separate files for tables, everything is in ibdata1. I started

Re: Recover dropped database

2012-10-26 Thread Lorenzo Milesi
innodb will not be consistent if there are parts overwritten in the meantime or small pieces are not recovered 100% I took a lvm snapshot few minutes after the happening, and the sql server is barely used so it shouldn't be overwritten.. -- Lorenzo Milesi - lorenzo.mil...@yetopen.it GPG/PGP

Re: Recover dropped database

2012-10-26 Thread Derek Downey
That's rough. The only thing I could suggest is try out Percona's data recovery tool ( https://launchpad.net/percona-data-recovery-tool-for-innodb ) They have a blog on how to use it in a specific scenario (deleted rows from a single table) here:

Re: Recover dropped database

2012-10-26 Thread Reindl Harald
Am 26.10.2012 16:15, schrieb Lorenzo Milesi: innodb will not be consistent if there are parts overwritten in the meantime or small pieces are not recovered 100% I took a lvm snapshot few minutes after the happening, and the sql server is barely used so it shouldn't be overwritten.. this

Re: Recover dropped database

2012-10-26 Thread Derek Downey
I do agree with Reindl that it is highly unlikely to work, but without specifics of how busy your DB is and how much write activity you have, it will at least give a shot for perhaps some data. Derek Downey On Oct 26, 2012, at 10:29 AM, Reindl Harald h.rei...@thelounge.net wrote: Am

Re: Recover dropped database

2012-10-26 Thread Lorenzo Milesi
That's rough. The only thing I could suggest is try out Percona's data recovery tool ( thanks for all the suggestions everyone. I'll give a try with this, otherwise restore an older dump. -- Lorenzo Milesi - lorenzo.mil...@yetopen.it GPG/PGP Key-Id: 0xE704E230 - http://keyserver.linux.it