Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
Reinstall - will I lose data?
Posted by: room58 (---.adsl.fast.co.uk)
Date: February 28, 2007 12:42PM

My version of WAMP has recently stopped working (Apache doesn't start). If I uninstall or try reinstalling over the top, will I lose my mysql data?

If I will, how can I access it and create a dump of it without web access (apache not working)

Options: Reply•Quote
Re: Reinstall - will I lose data?
Posted by: room58 (---.adsl.fast.co.uk)
Date: February 28, 2007 04:05PM

I found out that mySQL stores its data in a data folder (location will change but can be found by running SHOW VARIABLES LIKE 'datadir' from the mysql command prompt.

I grabbed this folder, along with htdocs and uninstalled. Then I reinstalled (same version of WAMP) and dropped my data/htdocs back over.

I'm not sure this is the *best* way to mamage this but I was unable to grab a dump fo the data any way.

Options: Reply•Quote
Re: Reinstall - will I lose data?
Posted by: ALF (158.116.134.---)
Date: February 28, 2007 04:42PM

You can if you used MyISAM as the default table type. INNODB used a RAID system and it is not recoverable that way.

Good luck!!

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