Suppose you are running WAMP server on your local system and due to bad luck your WAMP server got corrupted or unable to start. You must have created some databases and tables in your MYSQL, then you would be unable to access these data. So, now here question arises that, any how we can get this data/databases/tables and recover our databases and tables.
Answer is "yes".
There might be several ways to recover data, but what I applied was very simple and hassle free. Let see, how I recovered my data.
I have applied this method on WAMP Server 3.1.7 on 64 bit Windows Server 2016.
Copy your old WAMP server data of location your_root_wampserver_folder\bin\mysql\mysql5.7.24\data ( in my case it was D:\wamp64\bin\mysql\mysql5.7.24\data ). Copy either data folder or data of data folder for recovery to any location.
Note:- You can see your all databases name as folder in data folder, you have been previously created.
Now back up your new installed WAMP server MYSQL data folder (location your_root_wampserver_folder\bin\mysql\mysql5.7.24\data) data to any safe location.
After backing up after data folder of your new system, copy the old data folder to new data folder.
Important :- Both WAMP versions should be same.
Answer is "yes".
There might be several ways to recover data, but what I applied was very simple and hassle free. Let see, how I recovered my data.
I have applied this method on WAMP Server 3.1.7 on 64 bit Windows Server 2016.
Copy your old WAMP server data of location your_root_wampserver_folder\bin\mysql\mysql5.7.24\data ( in my case it was D:\wamp64\bin\mysql\mysql5.7.24\data ). Copy either data folder or data of data folder for recovery to any location.
Note:- You can see your all databases name as folder in data folder, you have been previously created.
Now back up your new installed WAMP server MYSQL data folder (location your_root_wampserver_folder\bin\mysql\mysql5.7.24\data) data to any safe location.
After backing up after data folder of your new system, copy the old data folder to new data folder.
Important :- Both WAMP versions should be same.
No comments:
Post a Comment