Last nite for some reason my db, MySql crashed giving error code 32.
I couldnt get arround that issue, so i decided to reinstall wamp server, however the wamp server which i reinstalled was an updated build version. Hence my db created using the older build version was not accessable.
Time to move MySql Data Files into the new build version of MySql.
Heres what you need to do.
1. Locate the data directory of the old and new versions.
MySql has a data directory where .FRM, .MYD and .MYI files are stored.
This is mentioned in my.ini (ini file of MySql).
2. In the new version, create a new database using the same name, (can use create database command) go back to windows explorer, you will now find a new folder created with the same name as the database name.
3. Copy all the files from our old build or versions data/
4. Go back to mysql tool that you use, check and confirm if the data is now updated on the new db.
And we are done.
No comments:
Post a Comment