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

1 vote167 views1 answer
Postgresql datetrunc too slow
SQL
8 votes171 views1 answer
Insert a select statement into a table
SQL
0 vote165 views1 answer
Renommer table sql
SQL
0 vote186 views2 answers
How to know the character set of an oracle databes
SQL
0 vote179 views1 answer
Get current date data in mysql
SQL
0 vote186 views1 answer
Trigger vérifier stock
SQL
2 votes180 views1 answer
Where clause for child record apex
SQL
5 votes191 views3 answers
Show indexes mysql
SQL
0 vote207 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote163 views1 answer
Select top 3 sql
SQL