/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

1 vote362 views2 answers
Mysql between
SQL
0 vote343 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
8 votes367 views1 answer
Sql limit results returned
SQL
0 vote361 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote343 views1 answer
Sql server select ignore dupplicates
SQL
1 vote385 views1 answer
Sql current timestamp
SQL
0 vote571 views1 answer
Multiple row join
SQL
0 vote409 views1 answer
Change date in pivot table to month in sql server
SQL
1 vote359 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
1 vote437 views1 answer
Sql select row with max date
SQL