help with mySQL files....

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
krsm1980
Forum Commoner
Posts: 25
Joined: Sat Jan 09, 2010 12:33 am
Location: IN
Contact:

help with mySQL files....

Post 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.
aravona
Forum Contributor
Posts: 347
Joined: Sat Jun 13, 2009 3:59 pm
Location: England

Re: help with mySQL files....

Post 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.
User avatar
krsm1980
Forum Commoner
Posts: 25
Joined: Sat Jan 09, 2010 12:33 am
Location: IN
Contact:

Re: help with mySQL files....

Post 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!!!!!
Post Reply