MySQL Database Files

In MySQL database installation, a directory has set of files which contain database metadata and data. That is the database schema and containing values. These files are,

• .frm – contains schema
• .myd – contains data
• .myi – contain indices

All the above list of files may not be available in MySQL database directory. It depends on various criteria like database engine, platform and etc. For example, if we use MyISAM engine, then data folder will contain all the above files, but for InnoDB, it contains only .frm files.

MySQL Directory Files Location

• Data folder path is set in MySQL configuration file
• MySQL configuration file in Windows is my.ini and Linux is my.cnf

Windows:

C:\Program Files\MySQL\MySQL Server 5.2\my.ini

Open my.ini and search for word “basedir”

• basedir – gives the location of MySQL installation
• datadir – gives the location of MySQL data directory

#Path to installation directory
basedir="C:/Program Files/MySQL/MySQL Server 5.2/"
 
#Path to the database root
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.2/Data/"

In that path, there is separate folder for each database with the name of the database itself. Database files can be used for backup to secure data, schema, and indices in general circumstances, migration and DB upgrade.

↑ Back to Top

• PHP
• jQuery
• WordPress
• MySQL
  • MySQL Basics
    • MySQL Data Types
    • MySQL Database Files
    • MySQL SHOW
    • MySQL CONCAT
    • MySQL OrderBy
    • MySQL Date Time
    • MySQL JOINs: An Introduction
    • MySQL Left Join
    • MySQL Right JOIN
    • MySQL vs MySQLi in PHP
• CSS

• Share
• Tweet
• Share

• Simple PHP Shopping Cart
• Skills Every PHP Freelancer Must Have
• PHP RESTful Web Service
• PHP Contact Form with jQuery AJAX
• jQuery AJAX Inline CRUD with PHP
• How to Become a Full Time Freelance PHP Developer and Consultant