Restore MySQL database after accident uninstallation of MySQL

When I uninstalled wamp, the database data was also gone. This not only uninstalled PHP and Apache, but also uninstalled MySQL Database. Only several directories left. One of them is "data". This dir consists of some files with extensions of .frm, MYD, MYI.

This can get you out of trouble, if you don't have backup anywhere else. So how to restore it? The method is so easy. First of all, you need to install a new instance of MySQL Database. Then, just copy the folder to the new installation's data directory. (You can get the data location from my.ini file)For example, you have a database "Bugzilla". Then you copy the "Bugzilla" directory to the new installation's data directory . If you are using wamp, the directory path would be something like this: C:\wamp\bin\mysql\mysql5.1.30\data\Bugzilla.

Category >> Uncategorized  
If you want someone to read your code, please put the code inside <pre><code> and </code></pre> tags. For example:
String foo = "bar";

  1. Diego Enrique Finol on 2011-2-24

    Cool, thanks 😉

  2. fucker on 2015-2-19

    fuck u

Leave a comment