Lost All MySQL database when upgrading to 1.8.3

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Lost All MySQL database when upgrading to 1.8.3

Postby bruceaj » 01. December 2013 16:42

I just upgraded to XMAPP 1.8.3 and now none of my MySQL database show up when I start phpMyAdmin. I get a completely new setup. How can I recover my prior databases?

Of course, I do not have backup <Damm>
bruceaj
 
Posts: 22
Joined: 15. December 2012 17:37
XAMPP Version: 5.6.3
Operating System: Windows 8

Re: Lost All MySQL database when upgrading to 1.8.3

Postby Nobbie » 01. December 2013 18:21

bruceaj wrote:I just upgraded to XMAPP 1.8.3 and now none of my MySQL database show up when I start phpMyAdmin. I get a completely new setup. How can I recover my prior databases?


Proceed to the mysql folder of Xampp (usually c:/xampp/mysql) and further proceed to the data folder (i.e. c:/xampp/mysql/data). If you used MyISAM data engine, you should see some folders inside the data folder. Each folder represents a database.

Can you see any folders / databases that matches to your expectations?

bruceaj wrote:Of course, I do not have backup <Damm>


So you are the next one to learn it the painfull way...

If we dont succeed to find the databases inside your data folder, your databases "have gone"....

P.S.: As there is no "upgrade package" (neither any upgrade procedure) for upgrading Xampp, what exactly did you do? Did you de-install a previous Xampp release? Or did you simply install the new Xampp "over" the existing?
Nobbie
 
Posts: 6760
Joined: 09. March 2008 13:04

Re: Lost All MySQL database when upgrading to 1.8.3

Postby bruceaj » 01. December 2013 20:05

I don't have to look. I deleted C:/xampp before I installed 1.8.3. When I initially tried to install, I got a message that c:/xammp (due to 1.8.1) was not empty. So, I deleted it. Next time I update I will do two things. One. backup my DB. Two, install in C:/xampp1.8.4.

I did not realize that the db were created in XAMPP root directory.

Thanks...
bruceaj
 
Posts: 22
Joined: 15. December 2012 17:37
XAMPP Version: 5.6.3
Operating System: Windows 8

Re: Lost All MySQL database when upgrading to 1.8.3

Postby Nobbie » 01. December 2013 21:15

bruceaj wrote:I don't have to look. I deleted C:/xampp before I installed 1.8.3.


Ouch!

Nothing else left to say....
Nobbie
 
Posts: 6760
Joined: 09. March 2008 13:04

Re: Lost All MySQL database when upgrading to 1.8.3

Postby hwalker1 » 09. May 2014 00:01

Would it not be possible just to re-name the current Xammp folder to old_Xammp, and then install the new version in the default Xammp folder?
All that you need to do then is to do an sql dump from one folder to the other for each database.
Or would you have to do the sql dumps first?

If you skip from a really old version like I did, you have a vertical learning curve and have to re-write just about all your web sites. I have been at it full time since last October and still have not quite finished.
Its a pity that the newer stuff is not backwards compatible. I just found that my timestamps from the old version do not work in the new one due to incompatibilities. Good job I retained my old tables and databases on a machine running the old version, so that they can be reconstructed. Another month's work to do, though I will update to this month's new version first!
It is not down to Xammp but the updated versions of PHP and MySql.
If it works don't fix it is my motto. :lol:
hwalker1
 
Posts: 26
Joined: 10. November 2010 11:59
Location: United Kingdom
XAMPP Version: 5.6.3
Operating System: Windows 7 Ultimate 64 bit

Re: Lost All MySQL database when upgrading to 1.8.3

Postby JJ_Tagy » 09. May 2014 01:21

hwalker1 wrote:...
Or would you have to do the sql dumps first?
...

Yes
JJ_Tagy
 
Posts: 544
Joined: 30. January 2012 13:44
XAMPP Version: 1.8.3
Operating System: Windows 7 x64

Re: Lost All MySQL database when upgrading to 1.8.3

Postby Kamil » 19. May 2014 12:12

bruceaj wrote:I did not realize that the db were created in XAMPP root directory.


Xampp is a webserver "packet". Believe me you preffer to have it installed this way. It's much easier to work with different versions of databases/php etc when they're installed in diffenerent "packet" folders rather then enigmatic C:/Program Files/Mysql
Kamil
 
Posts: 2
Joined: 19. May 2014 12:10
XAMPP Version: 1.8.2
Operating System: Win7 x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 58 guests