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 vote111 views1 answer
Create a view in sqlite
SQL
0 vote103 views2 answers
Oracle create tablespace autoextend
SQL
20 votes110 views4 answers
Sqlite create table if not exists
SQL
17 votes236 views4 answers
Show all tables in oracle
SQL
0 vote117 views1 answer
Show all mongodb
SQL
4 votes236 views2 answers
Sql display today's date
SQL
0 vote109 views1 answer
Mysql search like but first exact match
SQL
7 votes108 views3 answers
Postgresql dump and restore db
SQL
0 vote105 views3 answers
Fetlife
SQL
7 votes119 views2 answers
Sql server drop temp table if exists
SQL