xxxxxxxxxx
xampp mysql shutdown unexpectedly ?
open xampp shell & run this:
mysqld --console --skip-grant-tables --skip-external-locking
Do UpVote iff it works well for you.Thanks in adv.
It works if following error is showoing:
Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies,
improper privileges, a crash, or a shutdown by another method.
Press the Logs button to view error logs and check
the Windows Event Viewer for more clues
If you need more help, copy and post this
entire log window on the forums
xxxxxxxxxx
Go to xampp folder from window drive
Go to mysql folder
Find the ' data ' folder
make a copy of that folder and it should be named " data - Copy "
go to the data folder, find a folder called mysql,
performance_schema, phpmyadmin, test
delete all of those folder
then select all of the white files except a file called " ibdata1 "
next go to a folder called " backup "
open the folder, copy everything in that folder except a file called " ibdata1 "
( because we already have one )
go back to the folder called " data "
and paste all of what you've copied from the backup
and your problem is solved!
xxxxxxxxxx
Your mysql database needs to be repaired.
To do this please open the XAMPP Shell by clicking the Shell button in your XAMPP Control Panel and execute the following command:
mysqld --console --skip-grant-tables --skip-external-locking
Leave this black command line window open and click on the Shell button in the Control Panel again to open a second command line window and execute this command:
mysqlcheck -r --databases mysql --use-frm
After that you Can close both command line Windows and try to start mysql again normally from your XAMPP control panel
xxxxxxxxxx
STOP! Please do NOT delete ibdata1 file!
Deleting this file is like playing a Russian roulette with your databases, it could work and restablish 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:
Rename the folder mysql/data to mysql/data_old (you can use any name)
Create a new folder mysql/data
Copy the content that resides in mysql/backup to the new mysql/data folder
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)
Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
Start MySQL from XAMPP control panel
And, voilà!
xxxxxxxxxx
IMPORTANT: do NOT delete ibdata1 file. You could destroy all your databases.
Instead, first try using the MySQL backup folder which is included with XAMPP. So do next steps:
1. Rename folder mysql/data to mysql/data_old
2. Make a copy of mysql/backup folder and name it as mysql/data
3. Copy all your database folders from mysql/data_old into mysql/data (except mysql, performance_schema, and phpmyadmin folders)
4. Copy mysql/data_old/ibdata1 file into mysql/data folder
5. Start MySQL from XAMPP control panel