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 vote170 views1 answer
Ms sql print more than 1 variable
SQL
1 vote141 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote135 views1 answer
Create or replace view postgress
SQL
0 vote213 views1 answer
Run mysql xampp shell
SQL
0 vote138 views1 answer
Mariadb create index if not exists
SQL
0 vote124 views1 answer
Last date for each user sql
SQL
0 vote152 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote137 views1 answer
Grant owner postgresql
SQL
1 vote127 views1 answer
Mysql select row max date
SQL
1 vote162 views2 answers
Install sql server management studio ubuntu
SQL