Restoring a complete mysql database from a .sql file is pretty simple, you just need to browse the file in phpmyadmin, but what if you do not have the .sql file ???
Well I recently faced this terrible problem, the machine on which my wamp was installed went down and it had to be formatted, now all I could get from that machine was the wamp folder.....All my databases, etc were now just on hard disk, i did not know how to restore it to a new machine because i did not have the .sql file...
Did a lot of research and found that mysql database is actually stored in wamp/bin/mysql/data folder, there is a folder of your database name in this folder which has a lot od files mainly of three extensions: MYI, FRM, MYD
And finally I figured out the following simple steps to restore the db from MYI, FRM, MYD files
Well I recently faced this terrible problem, the machine on which my wamp was installed went down and it had to be formatted, now all I could get from that machine was the wamp folder.....All my databases, etc were now just on hard disk, i did not know how to restore it to a new machine because i did not have the .sql file...
Did a lot of research and found that mysql database is actually stored in wamp/bin/mysql/data folder, there is a folder of your database name in this folder which has a lot od files mainly of three extensions: MYI, FRM, MYD
And finally I figured out the following simple steps to restore the db from MYI, FRM, MYD files
- Create a database from phpmyadmin with the same dbname on your new wamp
- Copy the .FRM and .MYD tables to your wamp/bin/mysql/data/dbname folder
- Go to PHP myadmin repair all the tables
- Done
Tidak ada komentar:
Posting Komentar