/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 vote135 views2 answers
Select only columns that are not empty oracle sql
SQL
8 votes120 views2 answers
Sqlsrv default port
SQL
4 votes155 views1 answer
Rename stored procedure in sql server
SQL
0 vote116 views1 answer
How to login to mysql in homestead
SQL
0 vote112 views1 answer
Sql create table with references not primary key
SQL
1 vote119 views1 answer
Python escape mysql
SQL
8 votes114 views3 answers
Alter user root mysql
SQL
0 vote176 views1 answer
How to rename a database in tsql
SQL
6 votes122 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote163 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL