Recover data without logs

--0016e6464d8cfff50a046b30e130
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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 !

--0016e6464d8cfff50a046b30e130--

AW: Recover data without logs

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:liuwt123@gmail.com]=20
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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Recover data without logs

--0016368e1f86d0676c046b457732
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Still thanks,I will remember how to avoide this if the feature!

--0016368e1f86d0676c046b457732--

Re: Recover data without logs

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=gcdmg-mysql-2@m.gmane.org