MySQL database tables lost after re-install

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

MySQL database tables lost after re-install

Postby willothewisp » 26. October 2009 13:29

Hi,

I've been working happily with XAMPP for the Mac fr the last year with few problems. However this morning MySQL refused to start. No matter what I tried I couldn't solve the problem, so I thought the best thing to do would be to re-install XAMPP. A newer version was available too.

Firstly I couldn't install the new Xampp over the top of the old one, and I couldn't delete the xampp folder either (insufficient permissions). So I moved the old Xampp folder to my Trash, then installed the new one.
However of course this means that none of my databases exist in the new version. I had 20+ databases, and I desperately need to get them back!
Does anyone know how to do this?

Thanks,

Willo
willothewisp
 
Posts: 3
Joined: 26. October 2009 13:24

Re: MySQL database tables lost after re-install

Postby Nobbie » 26. October 2009 13:56

willothewisp wrote:So I moved the old Xampp folder to my Trash


And you did no backup before?

willothewisp wrote:Does anyone know how to do this?


Maybe there is still a copy in your trash box (pray for it!). If not, the data has gone forever.
Nobbie
 
Posts: 6679
Joined: 09. March 2008 13:04

Re: MySQL database tables lost after re-install

Postby willothewisp » 26. October 2009 14:05

I have backups for the last year on Time Machine.
willothewisp
 
Posts: 3
Joined: 26. October 2009 13:24

Re: MySQL database tables lost after re-install

Postby MegaChriz » 27. October 2009 08:41

If you are using Time Machine, then you need set back a backup of the time MySQL was still working.
The data of the MySQL databases is stored in '/Applications/XAMPP/xamppfiles/var/mysql'. Set back that folder (with Time Machine) and hopefully your MySQL databases are accessable again. If not, then you could set back the backup of the entire XAMPP installation.

For setting backups back:
1. Start Time Machine (in Applications)
2. Navigate to the time when MySQL still worked.
3. Navigate to the folder to set back and select it.
4. Click on the 'restore'-button (in the right bottom corner of the screen).
You will be asked if you want to overwrite the current folder or if you want to keep both versions. Choose what you think is right.
MegaChriz
 
Posts: 158
Joined: 16. February 2009 15:04
Location: Amersfoort, The Netherlands
XAMPP Version: 1.8.3-3
Operating System: Mac OS X

Re: MySQL database tables lost after re-install

Postby willothewisp » 27. October 2009 09:44

Hi MegaChriz,

Thanks for the advice, it was spot on. I was just unsure of where the MySQL data was actually stored.

Kind regards,

Willo
willothewisp
 
Posts: 3
Joined: 26. October 2009 13:24


Return to XAMPP for Mac OS X

Who is online

Users browsing this forum: No registered users and 5 guests