This is a batch script designed to fix common MySQL startup errors in XAMPP (like "Error: MySQL shutdown unexpectedly"). This error usually happens when database files get corrupted or another program blocks the MySQL port. The script automates the manual process of resetting the data folder while keeping your databases intact.
- Stop MySQL in the XAMPP Control Panel.
- Download the fix_mysql.bat file.
- Right-click the file and select Run as Administrator.
- When prompted, type Y and press Enter to confirm.
- Wait for the "Restoration Completed" message.
- Start MySQL in the XAMPP Control Panel.
The script performs the following steps automatically:
- Renames your current mysql\data folder to a backup name (e.g., data_old_20231014).
- Creates a fresh data folder using the contents of the mysql\backup directory.
- Copies your custom database folders from the old data folder to the new one.
- Copies the ibdata1 file to ensure your old databases are readable.
- This script assumes your XAMPP installation is in the default location: C:\xampp.
- Your old data is not deleted; it is renamed to data_old_[timestamp] inside the mysql directory.
- It is always a good habit to manually backup your mysql\data folder before running any recovery scripts.