How to fix mysql stop unexpectedly

How to fix MySQL shutdown unexpectedly
Note: If you don’t do following very carefully there are chances you can lose your databases. So be very careful to follow point 1.

1. Rename the folder xampp/mysql/data to xamppmysql/data_bk
2. Create a new folder xampp/mysql/data
3. Copy the content that resides in xampp/mysql/backup to the new mysql/data folder
4. Copy all your database folders that are in xamppmysql/data_bk to xampp/mysql/data
   Important: Do not copy the mysql, performance_schema, and phpmyadmin folders from xampp/mysql/data_bk
5. Finally copy the ibdata1 file from xampp/mysql/data_bk and replace it inside xampp/mysql/data folder
Start MySQL from XAMPP control panel

Similar codes

0 vote157 views1 answer
Sqlalchemy get ids
SQL
0 vote159 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote158 views1 answer
Sql list dates between two dates
SQL
0 vote256 views1 answer
Sqlite woth cmake
SQL
0 vote117 views1 answer
Deleted table in sql trigger
SQL
1 vote163 views1 answer
Postgresql can you have null foreign key
SQL
0 vote226 views1 answer
Placements hackerrank solution
SQL
0 vote185 views1 answer
MySQL - How to find word with the most similar beginning
SQL
16 votes157 views3 answers
Update table from another table
SQL
0 vote166 views1 answer
Oracle to_number
SQL