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

7 votes313 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
-1 vote331 views2 answers
How to display top 50 rows?
SQL
17 votes360 views3 answers
Cast in sql server
SQL
0 vote357 views1 answer
Sql waitfor
SQL
4 votes413 views3 answers
Postgres drop all tables
SQL
16 votes389 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
4 votes340 views2 answers
Sql vs mysql
SQL
15 votes344 views2 answers
How to drop database name in postgresql
SQL
0 vote353 views1 answer
Count characters of string mysql
SQL
0 vote365 views1 answer
Mysql multiple count
SQL