/SQL/Error: mysql shutdown unexpectedly.

Error: mysql shutdown unexpectedly.

MySQL shutdown unexpectedly

Instead, first try using the MySQL backup folder which is included with XAMPP. So do next steps:

Rename folder mysql/data to mysql/data_old
Make a copy of mysql/backup folder and name it as mysql/data
Copy all your database folders from mysql/data_old into mysql/data (except mysql, performance_schema, and phpmyadmin folders)
Copy mysql/data_old/ibdata1 file into mysql/data folder
Start MySQL from XAMPP control panel

Error: mysql shutdown unexpectedly.

1_ Rename the folder mysql/data to mysql/data_old (you can use any name)
2_ Create a new folder mysql/data
3_ Copy the content that resides in mysql/backup to the new mysql/data folder
4_ Copy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)
5_ Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
=> Start MySQL from XAMPP control panel
*************************DONT DELETE ibdata1 FILE*************************

Error mysql shutdown unexpectedly

Solucion a mysql shutdown

-1

Similar codes

1 vote236 views1 answer
Sql padd let with zeros
SQL
18 votes231 views3 answers
Mysql query add column with default string value
SQL
4 votes230 views1 answer
T-sql get duplicate rows
SQL
8 votes271 views1 answer
Mysql dump restore
SQL
0 vote274 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote236 views2 answers
How to list all values of a column that start with a letter in sql
SQL
-2 votes248 views2 answers
Union all in sql
SQL
0 vote226 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
13 votes246 views1 answer
Views in sql
SQL
12 votes264 views1 answer
Run mysql instance in docker
SQL