backup database
Posted by: pamela91 (---.adsl.terra.cl)
Date: November 15, 2009 12:39AM

Hello you all,
hope you can help me.
I forgot to backup my databse from phpmyadmin but I backed up the entire Wamp folder.
Can i recover my databse from that folder? how can i load it again?

thanks!
Pamela.

Options: ReplyQuote
Re: backup database
Posted by: mjh_ca (---.hsd1.tn.comcast.net)
Date: November 16, 2009 01:54AM

Assuming WAMP is installed in C:\WAMP , the MySQL data files are located in

C:\wamp\bin\mysql\mysql5.1.33\data

(The folder mysql5.1.33 will be different depending on which version of WAMP / MySQL you are running, so modify the path to suit your configuration).

Shut down all WAMP services, remove the existing files in the data folder (backup first just in case), and then copy the files from the data folder in the backup into the new folder. Restart WAMP and confirm that the MySQL service started successfully (Left cilck WAMP icon > MySQL > Service, to check that it is running)

Note, this is only safe to do if you're running the same version of MySQL as you were running when you backed up the WAMP folder. If you are now running a newer version of MySQL from the backup, this *may* work but there may also be errors... no guarantees.

Options: ReplyQuote
Re: backup database
Posted by: yfastud (Moderator)
Date: November 16, 2009 05:54AM


Options: ReplyQuote
Re: backup database
Posted by: pamela91 (200.29.129.---)
Date: November 16, 2009 01:10PM

Thanks a lot mjh_ca and yfastud ! Problem solved!

Options: ReplyQuote


Sorry, only registered users may post in this forum.