FOLLOW US ON TWITTER



FOLLOW US



img/blogimg/xampp.jpg


@theprodevelopers 520

XAMPP - MySQL shutdown unexpectedly | How to fix MySQL crash unexpectedly


2021-12-06 00:19 · 2 min read

STOP! Please do NOT delete ibdata1 file!

How to handle this type of error appears in red color.

12:19:12 PM [mysql] Attempting to start MySQL app...
12:19:12 PM [mysql] Status change detected: running
12:19:13 PM [mysql] Status change detected: stopped
12:19:13 PM [mysql] Error: MySQL shutdown unexpectedly.
12:19:13 PM [mysql] This may be due to a blocked port, missing dependencies,
12:19:13 PM [mysql] improper privileges, a crash, or a shutdown by another method
12:19:13 PM [mysql] Press the Logs button to view error logs and check
12:19:13 PM [mysql] the Windows Event Viewer for more clues
12:19:13 PM [mysql] If you need more help, copy and post this
12:19:13 PM [mysql] entire log window on the forums

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

  1. Rename the folder mysql/data to any folder name.
  2. Create a new folder mysql/data.
  3. Copy all the content from mysql/backup to the new mysql/data folder.
  4. Copy all your database folders that are in mysql/data_old to mysql/data (skipping 4 folders the mysql, performance_schema, and phpmyadmin folders from data_old)
  5. Finally copy the ibdata1 file from the old folder and replace it inside mysql/data folder
  6. Start MySQL from the XAMPP control panel done.
TAGS:






POST COMMENTS
c
@ coder

Thanks for the post.

2022-03-05 11:05

Please login to post comment




POPULAR POSTS

best free web hosting services...
what is new in miui 11?...
free website ssl security using cloudfla...
do you want to make money online?...
CSS3 @IMPORT RULES...
What is HTML Anchor Tag and Hyperlinks?...
CSS3 RESPONSIVE UI...
How to host a web page in 10 minutes....
Tables HTML...
CSS3 FUNCTIONS...
How to use CSS3 Overflow Property?...
CSS3 FILTERS...


RECENT COMMENTS

2022-03-05 11:05
By coder on XAMPP - MySQL shutdown unexpectedly | How to fix MySQL crash unexpectedly
2021-10-12 12:34
By abnongoke on do you want to make money online?
2021-10-12 12:34
By abnongoke on how to get a free website domain name?
2021-10-12 12:34
By solar panel for shed on what is new in miui 11?
2021-10-12 12:34
By solar panel for shed on best free web hosting services
2021-10-12 12:34
By amos tanui on free website ssl security using cloudflare


SOCIAL SHARE



FOLLOW US ON TWITTER



FOLLOW US ON FACEBOOK



FOLLOW US







Recent Blogs



Contact Us

Subscribe Our News-Letter



Kashipur, 244713
Uttarakhand, India



© blog.theprodevelopers.com 2024. All Rights Reserved. Powered by Pro Developer