mysql shutdown

Solutions on MaxInterview for mysql shutdown by the best coders in the world

showing results for - "mysql shutdown"
Serena
05 Sep 2017
1STOP! Please do NOT delete ibdata1 file!
2
3Deleting 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.
4
5Instead, first try using the MySQL backup folder which is included with XAMPP. So do the next:
6
7Rename the folder mysql/data to mysql/data_old (you can use any name)
8Create a new folder mysql/data
9Copy the content that resides in mysql/backup to the new mysql/data folder
10Copy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)
11Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
12Start MySQL from XAMPP control panel
13And, voilà!