xampp-server-mysql-db-not-starting-solutions-backup-db-restore

Xampp server Mysql db not starting how to recover db and make it working possible without backup

Some time you can see your XAMPP server not starting specially MYSQL database not start in XAMPP. It refuse to fail to start always. Today I also faced same issue and my bad I was not having backup of the db almost 15 database no backup. So I was struggling so much to recover it and you know once mysql not start then there we hopeless since we cant see our data.

if you forget to keep backup, but don't worry, here I  found the good way to restore  all mysql db's in xampp server in window , mac and Linux.

Steps are below after the screen shot.

 

 

Step 1: Stop your Xampp Control and exit.

 

Step 2: Go to your apache folder , example in my case I will go

 

C:jayxamppmysqldata

 

screen shot is below:

 

 

Step3: Keep the backup of 2 folder in your desktop or somewhere.

 

C:jayxamppmysqldata[FOLDER]

 

C:jayxamppmysqlbackup[FOLDER]

 

Screen shot below

 

STEP 4: Now you take backup folder and rename it  data which you have from STEP 3

 

Step 5: Copy ibdata1 file as below screen shot from backup folder mentioned in STEP 3

 

 

and PASTE it under data folder from STEP 4 example below in my case.

 

C:jayxamppmysqldata

 

Step 6: Now you can copy all the database or whichever db you want to restore from step 3 above

 

Reference ^{Step3: Keep the backup of 2 folder in your desktop or somewhere.}

 

^{C:jayxamppmysqldata[FOLDER]  --which you keep backup in desktop}

 

^{AND PASTE IT into C: actual folder where your xampp is running ex in my case.}

 

 

 

^TO

 

^{C:jayxamppmysqldata}

 

^{Screen shot is below}

 

 

   Share on Facebook