How To Fix the XAMPP Error: MySQL shutdown unexpectedly

In this tutorial, I will show you how to resolve the problem with MySQL that shuts down [MySQL] unexpectedly. so when you start it, it simply does not start. so it says that, [this may be due to] a blocked port which is not true [in my case]. so let's open mysql folder here, the first thing you need to do is just to backup. Let me change [from data] to data_old. then let me create a new one, called data. Let's go to backup folder, you can copy everything so there are three system folders, and [it] comes withe one database, called test. and other files, so , just select them all [and] copy. go [back] to data [folder], and] paste it go [back] to data_old [folder], let's copy to two databases, test and wp. that one I created for Wordpress. So let me copy. [if you] have other databases, you can copy except mysql, performance,schema and phpmyadmin. so, paste it. when you paste it, you need to replace previous one. In my case, test database. We need to copy one more. so, data_old. Look for ibdata1 file. Copy and go back to the data folder. Paste it. Replace. Try it (to run MySQL) again. It runs. [and then] stop, and run it again. That's how we fix the problem. Thank you!

Channel: Ken

Views: 221,952

Keywords: Java programming language, event-driven programming, object-oriented programming, Programming, java Programming, netbeans, javafx, scene builder, java, java tutorial, javafx tutorial, apache netbeans, intellij, javafx scene builder, Error: MySQL shutdown unexpectedly

Id: XH8wOgkSukk

Length: 2min 54sec (174 seconds)

Published: Wed Apr 07 2021