Important: do not delete the 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:
- Rename folder
mysql/data
tomysql/data_old
- Make a copy of
mysql/backup
folder and name it asmysql/data
- Copy all your database folders from
mysql/data_old
intomysql/data
(exceptmysql
,performance_schema
, andphpmyadmin
folders) - Copy
mysql/data_old/ibdata1
file intomysql/data
folder - Start MySQL from XAMPP control panel
And, voilĂ !
As mentioned by some users, this is an emergency solution, not a permanent one. After recovering your data is strongly recommended to back it up, and reinstalling XAMPP, because the failure is related to a malfunction from some of the files of XAMPP, not the databases.