Then, add the content from your server (step 1) without replacing the previously mentioned files and directories. In the local mysql/data folder of XAMPP you will need to delete all the original content except for the following directories (they can't change, so be sure to remove those directories from the data of your server): Add content to local mysql/data folderĪs next you need to create a backup of your mysql/data folder of xampp locally in case that something fails, so you will only need to use the old content of mysql/data and everything will be normal again. Once you have this data, proceed with the next step. This data has a format of folders with the name of every of your databases, inside those folders you will find IDB and FRM files that contain theoretically the data of your databases and you will be able to recover them as long as they aren't corrupted:Ĭreate as well a backup of the original data inside the data folder of Xampp, in case that you want everything to work before starting with this tutorial. 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 kommentar(er)
