How to repair mysql in xampp windows

Question: How to repair mysql in xampp windows

Answer:

  1. You can check for the error log file that may help you finding out the problem
  2. rename the data folder in mysql folder as data.old
  3. copy the backup folder and renmae it to data
  4. copy the ibdata1 file from data.old into new data folder
  5. copy the folders that are databases into new folder
  6. try starting the mysql server. hopefuly it will work

Note: ibdata1 file has the tables detail of all databases and the folders have only the database and table names in it

Leave a Comment

Scroll to Top