Page 1 of 1

help with mySQL files....

Posted: Tue Jan 19, 2010 5:57 am
by krsm1980
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.

Re: help with mySQL files....

Posted: Tue Jan 19, 2010 6:05 am
by aravona
if you still have the program you should be able to export them with phpmyadmin, then import them into your new system. There is a command line code to import/export mysql databases but you would need to check your manual.

Alternatively:

\mysql\data\dbname\tablename.

Re: help with mySQL files....

Posted: Tue Jan 19, 2010 6:47 am
by krsm1980
as i have mentioned that, i am using it @ localhost...

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

enjoy!!!!!