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 vote317 views1 answer
Horizontal join sqlite
SQL
3 votes306 views4 answers
Mysql create table from select statement
SQL
23 votes292 views6 answers
Create table sql
SQL
0 vote300 views1 answer
Sql server is not
SQL
0 vote346 views1 answer
Run sql script file and changes db name in this file using c#
SQL
1 vote322 views1 answer
Rails run native ssql query
SQL
2 votes366 views1 answer
Datefromparts mssql
SQL
16 votes313 views6 answers
Mysql find and replace
SQL
2 votes311 views1 answer
Oracle sql concatenate results into string
SQL
5 votes314 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL