Transferring Databases
Posted by: helliax (---.dhcp.insightbb.com)
Date: November 30, 2012 12:27AM

Hey everyone. First time posting on this site. I am a developer that had wamp on my computer. After getting a virus and frankly it was just time, i decided to reformat.

I backed up everything i needed to but wasnt sure about how i would back up my database so after doing some research i decided to copy the whole wamp folder. Now im not sure how to get it back. What files do i need to copy over? Thanks!

Options: ReplyQuote
Re: Transferring Databases
Posted by: RiggsFolly (---.as13285.net)
Date: November 30, 2012 10:34AM

Look in the backup for wamp\bin\mysql\mysqlx.y.z\data

This is where the databases are held if you are using MYISAM tables.

backup the current version of this folder ( rename to mysql_new) and them copy the old folder into the \data\ folder.

If you are using the same version of MySQL this could be all you need to do.
If you are using a newer version of MySQL there is a program called mysql_upgrade.exe, in the bin folder, run that and it should upgrade the MySQL owned tables and also your own databases.

Options: ReplyQuote
Re: Transferring Databases
Posted by: helliax (---.dhcp.insightbb.com)
Date: November 30, 2012 12:39PM

Thank you!!!!!!

Options: ReplyQuote


Sorry, only registered users may post in this forum.