where is database file of MySql

Question

hi every one, well my problem is that i dont know where is store database file in mysql. if you know that let me know like Sql server have created DBL file in Sql server2005 but in mysql which name of database file and what is the Extenstion of it. if u know then please tell me its too urgent thanks in Advance

Kirtan Patel · Answer

physical Location of Database is in installation path /data Folder for each Database it creates a New Folder :) for in my computer i want to know the path for database "test" then it will be C:\ProgramData\MySQL\MySQL Server 5.1\data	est

theLizard · Answer

@Kirtan, Teaching is NOT doing the work for someone it is giving enough information so that the student can go and learn how to do it for themselves. You tend to ask people for their code so that you can do the work of solving their problem, how is this teaching anyone. If people know they can get someone else to do their work why would they bother to think for themselves, this forum appears to have a lot of these people asking someone else how to do something. Yes newbies should be given a little more help but they should also be encouraged to think for themselves.

Kirtan Patel · Answer

@lizard Friend, I have not copied your answer but I have given answer in my own way that normal user can understand easily.. and btw you failed to teach the solution to user in easy way that's your problem not mine :)

theLizard · Answer

WOW Kirtan, you take someone else's answer and use it as yours, you must be a really good programmer coming up with ALL your own answers. Naim, 'Software Developer', you have a long way to go before you can call yourself that, you are on training wheels along with Kirtan.

theLizard · Answer

When you create your database the location is the name of the database in the 'DATA' path where your version of MySql was installed. c:\installation path\DATA\your database name You should also realize that each table in the database is represented as a file in this folder so if your database has 5 tables then you will see 5 files [table name] with the extension .frm in the DATA\database name folder plus a db.?? file One thing you have not said is what you are going to do with this information? are you going to distribute the files to other computer systems, what? If you are, how are you going to make the database visible to the MySql installation on the target system, will the target system have MySql installed? What do you know about ODBC DSN's? Do you know how to programatically add the DSN to the ODBC administrator? If you want to be a software developer you will need to know these things, you also need to know the registry and where and how to find registry keys relating to software installations. knowing where the files are is just one part of your problem

Naeem Khan · Answer

i don't want that sir ... i m asking about physical file of Data Base . means where is the structure file of My Data Base. and where is Store in my system.. hope you understand what i want.... please reply me fast thanks in Advance

Kirtan Patel · Answer

Friend , you can always back up your database by running simply two commands at mysqlPromt that will produce compressed archive file for you :) just follow the article http://www.roseindia.net/mysql/mysql_backup_restore.shtml

Naeem Khan · Answer

thanks for the reply sir... sir i got some information i just want to confirmation if i want to take some data from client then how can take data from client . should i take full root which is name database name or like have one DBF... where i get all data of client. hope you get it my problem . if u know then please tell me thanks in Advance Naim Khan

Lalit M · Answer

Hi, Try this steps --------------- 1) Locate the my.ini , which store in the MySQL installation folder. For Example, C:\Program Files\MySQL\MySQL Server 5.1 \my.ini 2) Open the "my.ini" with our favor text editor. #Path to installation directory. All paths are usually resolved relative to this. basedir = "C:/Program Files/MySQL/MySQL Server 5.1/" #Path to the database root datadir = "C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/" Find the "datadir", this is the where does MySQL stored the data in Windows.

Naeem Khan · Answer

its not working please tell through steps . still i did not get any solution............. please reply me fast... thanks in Advance

Lalit M · Answer

this link may be help try this .

where is database file of MySql

Nanhe Siddique