MySQL Forums
Forum List  »  Spanish

Re: MySQL recovery himself after detect error loosing information
Posted by: Jesús Uzcanga
Date: January 12, 2016 07:09AM

Hi Shora

First of all this section of the forum is only for spanish users, however i'll try to help you.

This event log is common when server is shutting down without stop the mysql-server service (mysqld_xxx) and normally no data is lost.

Yoy can check in your data folder if your server has some .bin file. This files save every single one transaction, included updates, alter tables, deletes and even insert intos... If you have this files, then you have a chance. (read about mysqlbinlog function).

Another solution you must try is the innodb force recovery function. (Please read this page: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html).

I hope you can resolve you problem and any question please let me know.

___________________________
Ing. Jesús Alfredo Uzcanga
Twitter: @JesusUzcanga

We learn the 20% of what we HEAR,
the 50% of what we SEE,
the 80% of what we DO and
the 95% of what we TEACH.

____________________________________________________________
https://www.linkedin.com/in/jauzcanga/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL recovery himself after detect error loosing information
640
January 12, 2016 07:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.