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 vote138 views1 answer
Mysql where in maintain order
SQL
9 votes127 views3 answers
Show table columns mysql command line
SQL
0 vote121 views1 answer
Alter table add foreign key mariadb example
SQL
1 vote180 views1 answer
Size of all tables in a schema oracle
SQL
3 votes137 views1 answer
Oracle apex call duration
SQL
-1 vote127 views3 answers
Compute age mysql
SQL
1 vote132 views2 answers
Sql groub by count
SQL
2 votes145 views1 answer
Use cases condition in sql query laravel
SQL
0 vote140 views1 answer
Sqlalchemy one column of two has to be not null
SQL
2 votes174 views3 answers
3 days back in sql server
SQL