Error mysql shutdown unexpectedly

MySQL shutdown unexpectedly

Instead, first try using the MySQL backup folder which is included with XAMPP. So do next steps:

Rename folder mysql/data to mysql/data_old
Make a copy of mysql/backup folder and name it as mysql/data
Copy all your database folders from mysql/data_old into mysql/data (except mysql, performance_schema, and phpmyadmin folders)
Copy mysql/data_old/ibdata1 file into mysql/data folder
Start MySQL from XAMPP control panel

Error: mysql shutdown unexpectedly.

1_ Rename the folder mysql/data to mysql/data_old (you can use any name)
2_ Create a new folder mysql/data
3_ Copy the content that resides in mysql/backup to the new mysql/data folder
4_ Copy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)
5_ Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
=> Start MySQL from XAMPP control panel
*************************DONT DELETE ibdata1 FILE*************************

Error mysql shutdown unexpectedly

Solucion a mysql shutdown

-1

Similar codes

4 votes169 views4 answers
Remove duplicate old value in mysql
SQL
2 votes126 views1 answer
SQL IF ELSE
SQL
3 votes139 views1 answer
Oracle transaction commit rollback example
SQL
2 votes124 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote183 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote189 views1 answer
Postgres dump sql insert
SQL
0 vote134 views1 answer
How to list function in psql
SQL
0 vote130 views1 answer
Ms Sql set us timezone
SQL
16 votes138 views6 answers
Install sqlite3 python
SQL
0 vote150 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL