we have a problem in our system. what if i try bench restore ? what happen if ill try ?
bench restore command takes a .sql backup and restores it in your database
How to restore a database from a backup (bench backup & bench restore)?
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
start mysql service via
sudo systemctl mysql start
this error occurs when mysql service has shutdown or was not started
@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
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
- sudo mysqld --tc-heuristic-recover=ROLLBACK
in this rollback process end it will says restart mysqld with –tc-heuristic-reocver
- sudo service mysqld restart
and then check mysql status
Bench update i get this - pymysql.err.OperationalError: (1045, u"Access denied for user