Lose all tables on MySQL Databases after upgrading XAMPP
Posted:
24. March 2014 12:38by Angki
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?
Re: Lose all tables on MySQL Databases after upgrading XAMPP
Posted:
24. March 2014 12:58by Nobbie
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.
Re: Lose all tables on MySQL Databases after upgrading XAMPP
Posted:
24. March 2014 14:36by Angki
thank you. i have the backup of whole data folder. will to replace the ibdata1.
Re: Lose all tables on MySQL Databases after upgrading XAMPP
Posted:
24. March 2014 14:39by Angki
thank you Noobie it's worked
got the tables back. thank you once again!