MySQL related file types and basic information
Kedar
This post covers the basic information of files that MySQL Server uses / creates for various tasks. Update: Various files in MySQL 8.0 Refer following updated article for latest information…
Browsing Tag
mysql data files
1 post
7 responses to “MySQL related file types and basic information”
that is possible to change the path of TMD file? i know that by default is the path of sql tables. (/var/lib/mysql/…)
I do not think we can change that Tarik. By default it’s data-directory. I’m do not think changing temp-dir path will also affect this.
Cheers.
Thanks Shantanu,
Updated above.
.TRG for storing trigger info
Pavel,
[table-time].BAK is created when myiasmchk is executed with -B option.
Thanks for pointing on that as I reminded of one more file-type thats getting created, TMD when we REPAIR TABLE.
.TMD
This is an intermediate data file for a table that needs to recreate its data file.
.BAK – backup files created during repair. Names are like [original table name]-[timestamp of repair].BAK
PS: sorry for posting twice, >< where recognized like tags in filename pattern
.BAK – backup files created during repair. Names are like -.BAK