Skip to content

Instantly share code, notes, and snippets.

@hrbullon
Created April 21, 2022 13:14
Show Gist options
  • Save hrbullon/15a1522ee47dcdc30366ff504593b369 to your computer and use it in GitHub Desktop.
Save hrbullon/15a1522ee47dcdc30366ff504593b369 to your computer and use it in GitHub Desktop.
##How to solve Error: MySQL shutdown unexpectedly
#IMPORTANT: do NOT delete ibdata1 file. You could destroy all your databases.
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment