Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

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.

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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