mysql unexpected shutdown xampp code example

Example 1: mysql shutdown unexpectedly xampp

1. Exit Xampp and navigate to xampp/mysql/data directory
2. delete the ibdata1 file
3. restart the XAMPP server

or

1. Exit Xampp and navigate to xampp/mysql/data directory
2. delete the ibdata1, ib_logfile0,ib_logfile1,ib_logfile101 files
3. restart the XAMPP server

or

Try to check the error log at the installed location: /xampp/mysql/data/mysql_error.log

Example 2: xampp mysql shutdown unexpectedly

1. Exit Xampp and navigate to xampp/mysql/data directory
2. delete the ibdata1 file
3. restart the XAMPP server

or

1. Exit Xampp and navigate to xampp/mysql/data directory
2. delete the ibdata1, ib_logfile0,ib_logfile1,ib_logfile101 files
3. restart the XAMPP server

or

Try to check the error log at the installed location: /xampp/mysql/data/mysql_error.log
This can help you better debug the problem.
Also Note:

1. XAMPP might hit into port issue when you have skype also running.
2. There is a federated plugin issue that is common.

Tags:

Sql Example