Follow these steps and save your time and databases:- Go to your XAMMP installation, it’s mostly in C drive . Now inside mysql folder rename the folder data to data-old (or any other name you like) Create a new folder data under mysql folder Copy the contents of backup folder to the new data folder Now copy all your database folders that are in data-old folder to the new data folder (skip the mysql, performance_scheme and phpmyadmin folder) And the last, copy the ibdata1 file from data-old folder and replace it inside new data folder Restart your MYSQL server from XAMPP control panel . And done!
Short & to the point working PHP snipes.