We assume that you have all the content of the data folder of mysql that doesn't work in your server and we'll try to restore it. The first step is obviously having a copy of the data folder of MySQL that you want to restore in XAMPP (e.g /var/lib/mysql in Linux). Make a copy of the mysql/data content of your server A lot of luck (really, you will need it). This copy includes all the data from your databases, including the ibdata1, ib_logfile0 and ib_logfile1 files. An entire copy of the mysql data folder from the server that you are trying to recover e.g /var/lib/mysql in Ubuntu with a Plesk installation.A Clean installation of XAMPP (with the same or higher version of MySQL) that works and you are willing to destroy.In order to try to recuperate the data of an old MySQL installation in a new one, you will need: This means that the solution doesn't guarantee 100% integrity of your databases as some of them may end up being corrupt and you will be unable to dump them (however in such situation it is worth a try). It's worth to say that you will face this situation and apply this solution only in a real emergency case, where you were irresponsable enough to don't make backups of your databases or they are simply more than a month old.
0 Comments
Leave a Reply. |