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 vote136 views1 answer
Ignore case in string sql
SQL
2 votes150 views2 answers
Sql lag
SQL
2 votes135 views1 answer
Mysql virtual column
SQL
1 vote147 views1 answer
Flask sqlalchemy default value
SQL
3 votes150 views2 answers
MySQL query to get column names
SQL
5 votes140 views1 answer
Sql check if date is between 2 dates
SQL
0 vote166 views1 answer
Get total and distict row diff in sql
SQL
0 vote128 views1 answer
Get sum sqlite android
SQL
0 vote133 views1 answer
Why we have to set the password for my sql server
SQL
-1 vote146 views1 answer
Module operator in oracle sql
SQL