Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
Recovering databases
Posted by: Stador (---.tor.pppoe.execulink.com)
Date: October 14, 2007 10:14PM

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.

Options: Reply•Quote
Re: Recovering databases
Posted by: Stador (---.tor.pppoe.execulink.com)
Date: October 16, 2007 02:46AM

any ideas...
help would be much appreciated

Options: Reply•Quote
Re: Recovering databases
Posted by: jw_k (---.net-you.de)
Date: October 16, 2007 10:07AM

>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!

HTH
Jürgen

Options: Reply•Quote
Re: Recovering databases
Posted by: Stador (---.tor.pppoe.execulink.com)
Date: October 18, 2007 12:57AM

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.

Options: Reply•Quote
Re: Recovering databases
Posted by: yfastud (---.cable.mindspring.com)
Date: October 18, 2007 04:29AM

Quote

all i have is the wamp dir with everything still included in it.... .
As jw_k mentioned, if you have myisam db and do have everything in wamp folder, you can get your db back. If you're not sure how to, email me

my username at my domain name = my email

Have fun,

[test.jlbn.net] (Sample Testing Codes for PHP, MySQL, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

Options: Reply•Quote
Re: Recovering databases
Posted by: jw_k (---.net-you.de)
Date: October 18, 2007 11:59AM

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.



Post Edited (10-18-07 12:00)

Options: Reply•Quote
Re: Recovering databases
Posted by: Stador (---.tor.pppoe.execulink.com)
Date: October 18, 2007 08:34PM

Thanks ill give that a try, ill let you know how that goes.

Options: Reply•Quote
Re: Recovering databases
Posted by: Stador (---.tor.pppoe.execulink.com)
Date: October 18, 2007 11:22PM

Ya that worked really well, pretty happy about that
thanks for your your help...
CASED CLOSED

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login