[Solved] Error: MySql Shutdown Unexpectedly [2022 Update] MySql not starting in Xampp Server
[Solved] Error: MySql Shutdown Unexpectedly [2022 Update] MySql not starting in Xampp Server
Hello Everyone! Today in this video I am going to step by step guide you How to install solve MySQL not Starting in the Xampp Server problem. i.e Error: MySql Shutdown Unexpectedly.
Now XAMPP is a free and open-source cross-platform web server solution stack package developed by Apache Friends, consisting mainly of the Apache HTTP Server, MariaDB database, and interpreters for scripts written in the PHP and Perl programming languages.
Geeky Script (\r@GeekyScript) is Computer Science - Educational Videos Creator 🎉 You can support by buying a coffee ☕️ here — https://www.buymeacoffee.com/geekyscript
✻ I really hope you find this video useful. ♥
✻ Please click on the CC button to read the subtitles of this video.
Now how to solve this issue? We can solve this using these 6 easy steps…
Step 1: Rename the folder mysql/data to mysql/data_old (you can use any name)
Step 2: Create a new folder mysql/data
Step 3: Copy the content that resides in mysql/backup to the new mysql/data folder
Step 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)
Step 5: Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
Step 6: Start MySQL from the XAMPP control panel
That’s all… And there you go! Your problem got Solved!!
-------- More videos related to Xampp and WordPress --------- How to Install XAMPP Server on Windows 10 [ 2021 Update ] Step by Step Installation guide • How to Install XAMPP Server on Window…
How to Install WordPress in Xampp (Localhost) [ 2021 Update ] Step by Step Guide Xampp + WordPress • How to Install WordPress in Xampp (Lo…
The instructions in this video tutorial can be applied to laptops, desktops, computers, and tablets which run the Windows 10 operating system like Windows 10 Home, Windows 10 Professional, Windows 10 Enterprise, Windows 10 Education. This tutorial will work on all hardware manufacturers, like Dell, HP, Acer, Asus, Toshiba, Lenovo, and Samsung.
Topics addressed in this tutorial: How To Fix MySql Shutdown Unexpectedly MySql not opening in Xampp Xampp MySQL error Error: Mysql shutdown unexpectedly
--------------------------------------------------------------------------- MY RELATED VIDEOS: ✻ All about Android Studio: • How to install Android Studio on Wind… ✻ All about PostgreSQL: • How to Install PostgreSQL \u0026 pgAdmin 4… ✻ All about MongoDB: • How to install MongoDB on Windows 10 … ✻ All about MySQL: • How to Install MySQL on Windows 10 [ … ✻ All about WordPress: • How to Install WordPress in Xampp (Lo… ✻ All about Java Spring: • Spring Framework | Spring setup in Ec… ✻ All about Maven: • Maven project in NetBeans [ 2021 Upda… ✻ All about eBook: • How to Create an Ebook for FREE
--------------------------------------------------------------------------- THANK YOU so much for watching! Please make sure to LIKE and SHARE the video and SUBSCRIBE to the channel for more such videos :)
--------------------------------------------------------------------------- CONNECT WITH ME ON: ✻ Website: https://geekyscript.com/ ✻ LinkedIn: https://www.linkedin.com/in/geekyscript/ ✻ Twitter: https://twitter.com/GeekyScript ✻ Email: [email protected] ✻ YouTube channel: / geekyscript --------------------------------------------------------------------------- Song: Jarico - Island Music promoted by #BackgroundMusicWithoutLimitations Watch: • Free Background Music For Youtube Vid… Free Download: https://bit.ly/3n3snwj ---------------------------------------------------------------------------
Content
0.24 -> hello everyone I welcome you to my
channel today I'm going to show you
4.24 -> a very easy and effective solution for an
issue that many of my students were asking
9.44 -> that is why this MySQL is not starting in
xampp server or why MySQL is you know shut
16.48 -> down unexpectedly in xampp servo so in this
video we are going to discuss these issues
35.12 -> so if you just you know go to the search icon and
search exam and just simply open this exam server
44.72 -> and if you just you know start your apache server
first and then as you can see this apache server
50.4 -> has been you know rightly started but when you
click on start for mysql you will be seeing that
56.4 -> this port first assigned and then later as you
can see this mysql has been you know shut down
62.16 -> unexpectedly and this mysql is currently
stopped and so is basically showing start
68.96 -> so if you again click on start you'll see first
this port has been assigned and then it will you
74.72 -> know automatically shut down unexpectedly right
so what's the issue right so for that you know
81.92 -> you need to just first minimize it and then go to
this pc and then go inside that c directory and
90 -> then xampp and then simply go inside this mysql
directory right so just go inside that and in here
98.16 -> we'll be seeing this data directory so the problem
lies over here so for that what you need to do is
105.12 -> you need to just you know simply right click on
it and then rename and now just you know simply
111.68 -> rename it to old just old right now you need to
simply create a new folder then just simply you
122 -> know give it a name asset and data so what
we are doing is we are just you know simply
129.76 -> replacing our corrupted data with our new data so
here you'll be seeing that so many files over here
137.36 -> but this is just newly created data we have no
data so for that sql you know rightly provided
144 -> a backup solution so this is the directory
where you know you will be getting this backup
150.32 -> files so what you need to do is you need to just
you know simply select all files and then just
156.48 -> simply right click on it and then copy then just
go a directory back and here you'll be getting
162.8 -> this data directory that is newly created then
just you know simply right click on it and then
167.2 -> just paste give it a time to you know copy all the
backup files from backup to data so now that you
175.36 -> know you have rightly copied all backup files in
your data directory that you have you know newly
182 -> created and now it's time for you know to migrate
all databases that you have previously previously
188.88 -> created so for that you know just simply go inside
this data old directory that you know you have
195.04 -> just recently renamed and now just simply select
your databases that you have you know created
201.36 -> earlier so this mysql and wordpress is basically
you know mysql is a default database that usually
207.76 -> come from the after installing exam so you need to
create a click so you need to you know select this
214.16 -> mysql and wordpress is basically you know what a
database that i have created i have also made a
219.76 -> video on how to you know install wordpress and how
to use wordpress for free in your localhost so i
226.64 -> have made that video so far that i have you know
installed this wordpress so this is one database
231.92 -> that i have created in your case you might have
you know created some other databases so you will
237.12 -> be you know listing all those databases over here
all those databases folder rather so what you need
242.72 -> to do is you need to just simply select all those
folders then just simply you know right click on
248.24 -> it and then copy and now just go a directory back
and in here just you know go inside this newly
255.2 -> created folder that is this data now just you know
again you know right click on it and then paste
260.96 -> and now you'll be seeing these databases
that you have you know created earlier
266.56 -> has been you know rightly copied over here
just remember one thing what we did is we
272.4 -> we are basically you know selecting all databases
that we have created earlier not this performance
279.04 -> schema and phpmyadmin you need to leave these
two folders over here you need to copy only those
284.72 -> databases that you have created so we are leaving
these two folders over here this is very important
291.52 -> so now that you know you have rightly copied your
old databases now it's time for to copy this ib
298.56 -> data 1 file so for that just again go inside
this database old directory and then you will be
303.92 -> seeing this ib data 1 file it's 77 mb so just you
know again simply right click on it and then copy
312.72 -> and then go a directory back and in here just
you know go inside that newly created data then
318.4 -> again right click on it and then paste and and you
know it will tell you that you have already this
324.08 -> ib data 1 file so what we'll be doing is
we'll be just using simply replace this file
329.84 -> so that you know we get all our database
back and now just again just if you just
335.2 -> minimize it and then open your exam
and if you just again click on start
340.96 -> you'll be seeing that your issue has been rightly
solved now if you just again click on admin
351.36 -> and you'll be seeing this PHPMyAdmin has been you
know rightly opened over here and this is and here
357.6 -> as you can see this apache server has been you
know rightly started and also your MySQL has been
363.12 -> again rightly started so this is a small video
that I have made for many of my students who are
368.8 -> basically you know not being able to solve this
uh issue so that's all for this video friends,
376.48 -> uh so this is a small promotion of what
website this is basically our website
380.72 -> geekyskit.com you can check this our website
here you'll be getting many tutorials along
386.48 -> with some blogs that I have written over here
you'll be getting all those tutorials over here
392.16 -> right so that's all for this video friends
thank you very much for watching this video
395.6 -> if you like this video then please give it
a like and also do share with your friends
399.12 -> so thank you very much for watching
this video and god bless you all you
![[Solved] Error: MySql Shutdown Unexpectedly [2022 Update] MySql not starting in Xampp Server](https://img.howtoclicks.com/vi_webp/ipMedkjMupw/sddefault.webp)