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 -
-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.
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
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
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
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
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:
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
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
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
10 matches
Mail list logo