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

12 votes215 views4 answers
Mysql version
SQL
2 votes206 views1 answer
Insert from table tsql
SQL
1 vote223 views1 answer
Oracle sql first day of year
SQL
0 vote181 views1 answer
Provera dupliranih konatakata
SQL
0 vote215 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote223 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote224 views1 answer
Get last date join sql
SQL
0 vote203 views10 answers
John the ripper mysql
SQL
5 votes217 views1 answer
Oracle ORA-00054 origin
SQL
0 vote211 views1 answer
Casterar postgres
SQL