Re: Recover data without logs

2009-06-01 Thread ewen fortune
Weitao,

On Sun, May 31, 2009 at 10:13 AM, Weitao Liu  wrote:
> I had deleted some important data from my mysql server,who can tell how can
> I recover my data,I do not open the bin log,is there some other method?

If you are using InnoDB you may be able to recovery the data from the
pages if you did something like "DELETE * FROM..."

http://code.google.com/p/innodb-tools/

Cheers,

Ewen

>
> thanks a lot !
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: Recover data without logs

2009-06-01 Thread Weitao Liu
Still thanks,I will remember how to avoide this if the feature!


AW: Recover data without logs

2009-05-31 Thread Benedikt Schackenberg
O think not, did you make dumps of your database? If not you have to use
bin-log

-Ursprüngliche Nachricht-
Von: Weitao Liu [mailto:liuwt...@gmail.com] 
Gesendet: Sonntag, 31. Mai 2009 10:13
An: mysql@lists.mysql.com
Betreff: Recover data without logs

I had deleted some important data from my mysql server,who can tell how can
I recover my data,I do not open the bin log,is there some other method?

thanks a lot !


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Recover data without logs

2009-05-31 Thread Weitao Liu
I had deleted some important data from my mysql server,who can tell how can
I recover my data,I do not open the bin log,is there some other method?

thanks a lot !