HOW TO RECOVER MYSQL 5.7
We have a MySQL 5.7 Server that is now inaccessible. Last task performed was we ran a query that took several hours and was not completed. We resulted to restarting the services and the server itself hoping to terminate the session from the large query.
After restarting the server, we tried to manually start the MySQL server service but it gets "stuck" trying to start running serveral hours without completing.
Unfortunately, our database weekly backup has not started prior to the server going down. We need to recover the current data that is in the DB.
1. What can we do to be able to start the databse successfully?
2. What is the way to recover the data if the database server will not be started?
3. What are our options to salvage this database completely?
Subject
Views
Written By
Posted
HOW TO RECOVER MYSQL 5.7
282
March 20, 2024 09:16PM
Sorry, only registered users may post in this forum.
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.