Computer Stuffs

MySQL Data Files Extensions

25 Jul , 2014  

Just in case you are wondering how much space your MySQL data actually took on your disk, you can check them on the data files created. By default MySQL created these data files inside /var/lib/mysql. Then inside the folder you can find the name of your databases as folders. Inside these folders are some files used by MySQL to create your database. Files with these 3 extensions are the data files:

File Extension Purpose
.frm Table definition
.myd Table data
.myi Table indexes

You can use du to see the size of these files. Hope this information is useful for you!

Latest posts by Satrio G. Nugraha (see all)

,


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.