> 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
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 wrote:
>
>
> Am 26.10.2012 16:15, schr
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..
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:
http://www.mysqlperformanceblog.com/2012/02/20/h
> 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/PG
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
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 th
2012/10/25 Sabika M :
> We are in the process of switching to percona binaries of MySQL . I am
> using Percona 5.5.27 and monitoring the MySQL server with the MySQL
> Enterprise monitor. It starts up fine, but after a while I end up with
> MySQL monitor connections stacking up until the server beco
W dniu 2012-10-18 16:27, Stefan Kuhn pisze:
Hi everybody,
I want to get insert statements from a mysql database for a number of rows of
a table, specified by a where clause. I also need the inserts for the
datasets linked via foreign keys in other tables. So I need a sort of partial
dump, a bit l
