Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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.
Comment

PREVIOUS NEXT
Code Example
Sql :: SELECT MAX(age) FROM Customers; 
Sql :: oracle database connection visual studio 2019 
Sql :: sql fetch next 10 rows pdo 
Sql :: pl sql join 3 tables 
Sql :: database restoring error 
Sql :: how to count with except in psql 
Sql :: mysql select where field like in list 
Sql :: knex sqlite 
Sql :: Postpresql relation not found 
Sql :: insert new department and employee record 
Sql :: oracle archivemode 
Sql :: oracle sql date summer time 
Sql :: tsql default value when no value returned by query 
Sql :: sql server split string and insert into table select 
Sql :: compute age mysql 
Sql :: select into a new table mysql 
Sql :: pagination with row_number 
Sql :: SQL FULL OUTER JOIN With AS Alias 
Sql :: watch mysql command line 
Sql :: C# check if mysql query modified rows 
Sql :: many to many getting data mysql 
Sql :: sql query use select name inside where clause 
Sql :: does sql auto increment start at number if it is removed? 
Sql :: sql server agent not running 
Sql :: basic sql queries interview questions 
Sql :: group by join columns per table 
Sql :: ring connect to the database using the odbc_connect() 
Sql :: pl/pgsql declare variable 
Sql :: ring MySQL execute a query on the database then print the result. 
Sql :: get similar records in sql for a special number 
ADD CONTENT
Topic
Content
Source link
Name
5+3 =