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!
Printable View
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!
If mysql 5.1 uses the same setup as phpdev it will be:
disregard "\phpdev" if that does not apply to you.Quote:
C:\phpdev\mysql\data\(your database)
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?
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.
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)
Thread Moved
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
it's hidden diretory so you have to turn on "show hidden files and folders" in folder options..
<CHEERS
Josip!!