how to recover all database when migrate to 5.5.8 from 5.5.1

Posted by anirudha on Geeks with Blogs See other posts from Geeks with Blogs or by anirudha
Published on Fri, 17 Dec 2010 02:19:13 GMT Indexed on 2010/12/18 17:14 UTC
Read the original article Hit count: 212

Filed under:

the installation process of MySQL on windows are very simple as other software you need just configure them and they works.

but somebody after migrating their mysql server to 5.5.8 confuse that their old database is now gone but it’s not  you need to do something to get back

go to

C:\ProgramData\MySQL\MySQL Server 5.1\data

the programdata folder commonly hidden in any version of windows.

you find their some folder cut them all you want to recover.

note that don’t copy the file mainly in data folder just like err pid or log because they are configuration file and the configuration of mysql 5.1 and 5.8 both are different

after copy the folder  go to

C:\ProgramData\MySQL\MySQL Server 5.5\data

paste here the folder

restart mysql and all database is now in your hands.

© Geeks with Blogs or respective owner