Try Bench Restore?

1

we have a problem in our system. what if i try bench restore ? what happen if ill try ?

2

bench restore command takes a .sql backup and restores it in your database

3

we have a problem in our system

Please describe the problem then users can help you sort it out.

Share the steps and the errors you are encountering. It will make it easier for them to deduce what is the cause and how to mitigate it

4

hi guys thanks for your response.

once ill try to log in our system this what happen.

Capture
Capture1037×930 147 KB

5

start mysql service via sudo systemctl mysql start

this error occurs when mysql service has shutdown or was not started

6

@Denmark_Del_Puso if this was the solution please mark it as solution. Likewise others who are looking to solve a similar problem can benefit from this topic and not only the original poster

7

Mysql crash happens due Date exchange or you extremely shut down bench start(directly closing terminal )
if sudo systemctl mysql start not worked
then change your system date to current date
restart your system
use: following command

  1. sudo mysqld --tc-heuristic-recover=ROLLBACK
    in this rollback process end it will says restart mysqld with –tc-heuristic-reocver
  2. sudo service mysqld restart
    and then check mysql status
1 Like