Skip to content

Instantly share code, notes, and snippets.

@Korveld

Korveld/MySQL shutdown unexpectedly in XAMPP.

Created March 9, 2023 09:27
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Korveld/4a58405b3861f064dace0235eb49039f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Korveld/4a58405b3861f064dace0235eb49039f to your computer and use it in GitHub Desktop.
Download ZIP
MySQL shutdown unexpectedly in XAMPP.
Raw
MySQL shutdown unexpectedly in XAMPP.
1. Rename the folder xampp/mysql/data to xampp/mysql/data_old (you can use any name)
2. Create a new folder xampp/mysql/data
3. Copy the content that resides in xampp/mysql/backup to the new xampp/mysql/data folder
4. Copy all your database folders that are in mysql/data_old to mysql/data (except mysql, performance_schema, and phpmyadmin folders from data_old)
5. Now copy the ibdata1 file from xampp/mysql/data_old and replace it inside xampp/mysql/data folder
6. You can start MySQL again from control panel now
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment