Raviya Technical
Published in

Raviya Technical

XAMPP — MySQL shutdown unexpectedly

Deleting this file is like playing Russian roulette with your databases, it could work and reestablish everything, but also, probably could leave unusable every database you have.

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

  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
  6. Start MySQL from the XAMPP control panel

--

--

--

PHP, Laravel And Flutter Development

Recommended from Medium

Execute PHP scripts into HTML file by Modifying ‘.htaccess’ file

About ACM UTD

Top 3 things the average programmer aspires for during the Zuri Internship.

Impress is now stocking the Gold Series of Hard Drives from WD.

Way to Microservices: Contract Testing — A Spring/Pact Implementation

Bit Manipulation Handbook

Theory of Constraints — An Overviewfor Project Managers!

What is Web Scraping?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Raviya Technical

Raviya Technical

raviyatechnical.blogspot.com

More from Medium

Laravel Advance | How to Create Reusable Components in Laravel?

How to structure and generate external URLs in Laravel

How To Generate QR code in laravel 8 — Phpflow.com

How to make a custom command in Laravel * DevRohit Think simplified