/SQL/Error: mysql shutdown unexpectedly.

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

0 vote387 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
1 vote316 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
4 votes435 views1 answer
Oracle table statistics
SQL
0 vote389 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote375 views1 answer
Update having mysql
SQL
2 votes361 views1 answer
Get hour from date sql
SQL
0 vote373 views1 answer
Close sql query vb.net
SQL
3 votes366 views2 answers
Sql select data from last week
SQL
0 vote366 views1 answer
Oracle DROP PROGRAM
SQL
0 vote353 views1 answer
Mysql group by range
SQL