/SQL/MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes

MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes

I came across similar problem and tried this Stack Overflow answer by Fabrizio Valencia. It worked.

Stop there! Please do not delete anything! First try to do what I did.

OK, none of the listed answers here solved my problem, even, some of the answers were making me lost all my db data. So I did exactly what the error message in XAMPP message panel told me to do. So I did this:

Rename the folder mysql/data to mysql/data_old (you can use any name)
Create a new folder mysql/data
Copy the content that resides in mysql/backup to the new mysql/data folder
Copy all your database folders that are in mysql/data_old to mysql/data
Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
Start MySQL from XAMPP control panel
And, voilà. No databases lost, no ports changed, no run as administrator, no force recovery, no kill mysqld process, no restoring from previous versions, no more errors.

Source: dba.stackexchange.com

Similar codes

0 vote215 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
13 votes238 views3 answers
Mysqldump structure only
SQL
5 votes215 views4 answers
Mysql update column with value from another table
SQL
0 vote219 views1 answer
Starting mysql shell lampp ubuntu
SQL
1 vote214 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
9 votes222 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote208 views1 answer
Exit psql
SQL
1 vote251 views1 answer
Delete mysql ubuntu 20.04
SQL
2 votes201 views4 answers
How to find 2nd highest salary in mysql
SQL
1 vote194 views1 answer
Set statiscis on in sql server
SQL