Mysql shutdown unexpectly, two files, ‘ibtmp1 and mysql.pid’ are delete from de mysql/data folder. if I add the files again nothing happen, but If I pasted the data folder from a backup the issue is fixed, until a next time. I need some help, please.
What version of MySQL ?
Look in your mysql log file (usually /var/log/mysql/error.log, but may be different if your installation has been modified) , and see what errors are logged when it crashes and when MySQL attempts to restart.
Hello CG,
I am using Xampp-Windows x64-8.2.12.0 Vs 16 Zip.
It comes with MariaDB V. 10.4.32.
This is the Mysql log file:
thanks for your help>
Hi @dominti ,
It’s been a while since I used Xampp, but I think the log file is located in C:\xampp\logs. In that folder there should be an error log for the MySQL. The image you posted is from the startup MySQL log.
Hello @Yick Mo,
I found the Mysql log error file in the xampp/mysql/data folder. stll can’t see the cause of the issue.
Please, let me know if you see something?
Hi @dominti ,
Is there any more to the log than the screenshot? Is the mysql.log file being recreated each time you restart it? If so, is shouldn’t recreate the mysql.log file. It should be appending to it.
From what I can see, there is nothing wrong with your MySQL.
Since you are using windows, look at your windows “Event Viewer”.