up vote 1 down vote favorite
share [g+] share [fb]

I have reinstalled MySQL 5.0 to the same location (OS Windows XP), so after it databases stored in /data/ folder become invisible by MySQL. How I can to make it visible again ? All databases is MyISAM type.

link|improve this question
1  
Seems like this belongs on serverfault – mazzzzz Aug 14 '11 at 6:44
If you had made no changes to the data directory and did not overwrite the mysql directory there, all your databases would be visible and accessible. – Dan Grossman Aug 14 '11 at 6:47
feedback

migrated from stackoverflow.com Aug 14 '11 at 7:36

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 2 down vote accepted

Have you tried changing the data directory setting in my.cnf to the location with all the data?

The variable you should be setting is datadir = /path/to/data/directory

You should probably restart the server once you have done that.

link|improve this answer
Thank you, it helps. – Alexey Khaydukov Aug 14 '11 at 7:56
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.