Hey guys my computer recently crashed (winXPSP2) so i had to reformat. I was however able to recover my WAMP directory, and still have the copies of the databases i want to restore .frm files... i was wondering how i can get those databases back....
2 questions. is the .frm files what i need , do those hold the data? can someone provide me with a step by step guide to get tin back up and running... let me know thanks a lot.
>is the .frm files what i need , do those hold the data? no, myisam databases are folders in the mysql data dir containing 3 files per table, e.g., world/city.frm world/city.MYD /*data*/ world/city.MYI /*indices*/ world/country.frm world/country.MYD world/country.MYI (see [dev.mysql.com] ) only myisam tables can be restored by just copying the folders. be aware: the mysql folder is containing all credentials!
hey thx for the heads up on the .fm ... i do only have the .frm files in the mysql / my website dir .... is any way i can restore my databases ??? all i have is the wamp dir with everything still included in it.... .
how can i get wamp back up and running with the same dir as the old machine, is that possible? thx for your help so far , much appreciated.
If you only have .frm files in the database folders those tables are of type "innodb" and the data is stored in one (ore more) files like "ibdata1" in the mysql\data\ dir. you can try and just copy the whole mysql\data dir from your backup over to a fresh wamp5 installation (stopping the mysql server first of course). This also overrides the default ("root" w/o pw) user privileges ( the mysql\data\mysql\user.* ) and restores your old settings.