HELP! Where is the database stored in MySql 5.1?

[winman]

I hope this is the right place for this post. I want to know the exact path to stored database in mysql 5.1. Any help in this regard will be greatly appreciated.
Thanks in advance!

[Nightwalker83]

If mysql 5.1 uses the same setup as phpdev it will be:

C:\phpdev\mysql\data\(your database)

disregard "\phpdev" if that does not apply to you.

[winman]

Thanks for your reply. But in mysql folder I am not finding any folder named "data". Any idea why? Where else can the database be stored?

[Nightwalker83]

The "data" should be in the root folder for MySql 5.1.

Edit:

That is assuming that all the downloads of "MySql 5.1" store there files in the same locations. I downloaded the extracted version (mysql-noinstall-5.1.30-win32.zip) not the install version.

[ComputerJy]

It's in "C:\Users\All Users\MySQL\MySQL Server 5.1\data" for Windows Vista or "C:\Documents and Settings\All Users\MySQL\MySQL Server 5.1\data" for Windows XP (In case you're using the installed version of MySQL)

[RobDog888]

Thread Moved

[cromorrissey]

that questio troubled me so long...
in your mysql screen just enter

show variables;

then look for datadir variable... it will tell you where is your data...

on my PC is in dir


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

[cromorrissey]

it's hidden diretory so you have to turn on "show hidden files and folders" in folder options..

<CHEERS
Josip!!