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 vote353 views1 answer
This week mysql
SQL
9 votes351 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote369 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote323 views1 answer
Mysql sleep connections
SQL
6 votes792 views3 answers
Sql select last id
SQL
0 vote360 views1 answer
Sql value exists in column
SQL
2 votes346 views2 answers
Mysql date range
SQL
0 vote363 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote354 views1 answer
Mysql drop vs delete
SQL
0 vote341 views2 answers
Python mysql create table if not exists
SQL