krsm1980 — 2010-01-19T06:57:10-05:00 — #1
would you mind letting me where MySQL stores the databases locally?
i am working on WINDOWS Xp, and running mysql as localhost...
my sys got crashed, OS got wired, HDD still works fine...
would you plz help on that.....sothat i can locate the databases files and then reload them to new system.
thanks in advance.
krsm1980 — 2010-01-19T07:47:08-05:00 — #2
btw i got the details....its always in
C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data
and the file name is: ibdata1
That's for if you want to backup it manually.
one can copy this file for records and can paste in the same location to retrieve the databases and complete data.
I added this here, sothat others may also enjoy this....