Lose all tables on MySQL Databases after upgrading XAMPP

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

Lose all tables on MySQL Databases after upgrading XAMPP

Postby Angki » 24. March 2014 12:38

hi guys.
i'm currently just upgrade my XAMPP from 1.8.0 VC9 to 1.8.3 VC 11, then i lose all tables on my databases.

when uninstalling old version of XAMPP, i click NO on "remove mysql/data" prompt message.
can anybody help me please?
Angki
 
Posts: 3
Joined: 24. March 2014 12:34
Operating System: Win 8.1

Re: Lose all tables on MySQL Databases after upgrading XAMPP

Postby Nobbie » 24. March 2014 12:58

If you did not backup the data folder, you are in big trouble. Even if the uninstall does not remove any data, since MySQL 5.x the default engine of MySQL is INNODB and INNODB does not store databases and tables in folders and files (as MYISAM did in previous MySQL Releases), but it holds all databases and tables in a single file called "ibdata1".

With the installation of a new release, "ibdata1" will be overwritten by a new (empty) file.

If you have backuped your data folder, you can simply restore it to the current data folder.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: Lose all tables on MySQL Databases after upgrading XAMPP

Postby Angki » 24. March 2014 14:36

thank you. i have the backup of whole data folder. will to replace the ibdata1.
Angki
 
Posts: 3
Joined: 24. March 2014 12:34
Operating System: Win 8.1

Re: Lose all tables on MySQL Databases after upgrading XAMPP

Postby Angki » 24. March 2014 14:39

thank you Noobie it's worked :)
got the tables back. thank you once again!
Angki
 
Posts: 3
Joined: 24. March 2014 12:34
Operating System: Win 8.1


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 87 guests