MySQL Data Files Extensions
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!
Satrio is a self-proclaimed technology geek. He is currently employed by IBM Indonesia as an IT Specialist which handles IBM xSeries servers, IBM zSeries mainframes and multi vendor network devices. He listens to various kinds of musics (he personally believes that music should not be put into boxes such as genres and everybody is free to listen to whatever kind of music whenever they feel like it).
Latest posts by Satrio G. Nugraha (see all)
- In search of linux distro with beautiful desktop - October 21, 2015
- Mount Network Drive Using Windows CMD - January 28, 2015
- Install Dropbox on Linux - January 25, 2015
Comments RSS Feed
