/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

2 votes263 views1 answer
Add 2 hours to current time in MySQL
SQL
7 votes257 views3 answers
Sql get last inserted row
SQL
0 vote278 views1 answer
Sql log file inof
SQL
1 vote263 views1 answer
Mysql change root mysql_native_password
SQL
5 votes270 views4 answers
Rollback to in sql
SQL
23 votes285 views4 answers
Uninstall postgresql ubuntu
SQL
1 vote268 views3 answers
Mysql connection string
SQL
9 votes250 views6 answers
Sql insert into
SQL
2 votes251 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
1 vote246 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL