MySQL shutdown unexpectedly

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*************************

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

Solucion a mysql shutdown

-1

Similar codes

0 vote182 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote215 views1 answer
Sort by last two number sql
SQL
0 vote307 views3 answers
Insert or ignore postgres
SQL
1 vote178 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote209 views1 answer
Oracle insert single quote in string
SQL
2 votes175 views2 answers
Mysql all columns
SQL
0 vote230 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote186 views1 answer
Denormalise SQL command
SQL
-1 vote194 views5 answers
Not in sql
SQL
0 vote185 views1 answer
Fast sql column count
SQL