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.
help with mySQL files....
Moderator: General Moderators
Re: help with mySQL files....
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.
Alternatively:
\mysql\data\dbname\tablename.
Re: help with mySQL files....
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!!!!!
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!!!!!