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

Today I reinstalled Web-Developer Server Suite and although all my old PHP pages work, the databases don't... I copied them over from my backup folder and only some of the tables re-appeared.

How would I restore all data in the databases: when I look in phpMyAdmin some are missing or incomplete.

It's the first, and hopefully, last time I'll have to do such a thing... how should I handle this situation?

link|improve this question
50% accept rate
feedback

1 Answer

up vote 0 down vote

I have always restored a previous instance by copying the whole $PATH/lib/mysql/data folder to the new instance. Just ensure that the folder is owned by the new MySQL instance and everything should launch OK.

link|improve this answer
I did this; but one of my databases - mytvguide - has problems, some of the tables didn't re-appear when I did this. – avenas8808 Dec 16 '11 at 10:35
When I had tables or schema missing it was because some sub folders were still owned/readable by the old user. – Tim Dec 16 '11 at 13:50
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.