/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 vote174 views1 answer
Primary key reset in SQL database
SQL
0 vote112 views1 answer
What is the essence of SQL?
SQL
0 vote116 views1 answer
Get null value in sql
SQL
3 votes123 views1 answer
Create a table with an id in mysql
SQL
0 vote116 views1 answer
Order by with where clause in mysql
SQL
21 votes115 views1 answer
SQL cheat sheet pdf
SQL
0 vote113 views1 answer
Sql create text column limited values
SQL
1 vote110 views1 answer
Sql select all from one table and one column from another
SQL
9 votes110 views2 answers
Get first 3 letters in sql
SQL
0 vote118 views1 answer
Sql: extract day text from datetime value
SQL