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

7 votes290 views2 answers
Create index mysql cli
SQL
1 vote277 views2 answers
Login to mysql
SQL
0 vote296 views1 answer
Example database query
SQL
0 vote267 views2 answers
How to save result of sqlite query in a table
SQL
0 vote279 views1 answer
Sqlplus change user
SQL
0 vote267 views1 answer
Replace null value within column mysql
SQL
-1 vote288 views1 answer
Round up and down sql
SQL
0 vote280 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
1 vote281 views2 answers
List tables sqlalchemy
SQL
0 vote256 views1 answer
Opensuse status MySQL
SQL