Hi,
could your collegue please share steps he taken to recover data?
I'd be interested most definetely!
Thanks
2012/10/29 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 (suspa
-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!
>
> C
> 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 - http://keyse
> 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..
2012/02/20/how-to-recover-deleted-rows-from-an-innodb-tablespace/
I've never used it (yay backups!), so I can't tell you if it will work for an
entire dropped database.
Regards,
Derek Downey
On Oct 26, 2012, at 10:15 AM, Lorenzo Milesi wrote:
>> innodb will not be con
> 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
Greetings All,
I have made a terrible newbie stupid mistake and I am wondering if there is anything I
can do to save my bacon
I made a backup of a database which failed, but mysql didn't tell me :-( Stupidly a
dropped the database, as you do and then the restore failed . because there
Greetings All,
I have made a terrible newbie stupid mistake and I am wondering if there is anything I
can do to save my bacon
I made a backup of a database which failed, but mysql didn't tell me :-( Stupidly a
dropped the database, as you do and then the restore failed . because there
Greetings All,
I have made a terrible newbie stupid mistake and I am wondering if there is anything I
can do to save my bacon
I made a backup of a database which failed, but mysql didn't tell me :-( Stupidly a
dropped the database, as you do and then the restore failed . because there
Friday, February 15, 2002, 2:23:52 AM, Lars Heidieker wrote:
> Just copy the backup files into the database dir and the database should be
> back.
Are you sure that it's not need to CREATE it first ?
> At 08:22 AM 2/15/2002 -0500, Paul wrote:
>>Hello mysql,
>>
>> I dropped an entire database
Just copy the backup files into the database dir and the database should be
back.
Lars
At 08:22 AM 2/15/2002 -0500, Paul wrote:
>Hello mysql,
>
> I dropped an entire database but I have the frm, myd and myi files
> in a backup.
>
> What are the complete steps to restoring this database?
>
Hello mysql,
I dropped an entire database but I have the frm, myd and myi files
in a backup.
What are the complete steps to restoring this database?
Thank you for the help.
--
Best regards,
Paul mailto:[EMAIL PROTECTED]
-
16 matches
Mail list logo
