/etc/mysql/my.cnf, but the location and name depends on the particular installation. Note that this is not the only way of configuring the server, some systems does not have one even and rely on the command options to start the server and its defaults values.
ibdata1is a 10MB autoextendable file that MySQL creates for the shared tablespace by default.
Unknown commanderrors on any clients attempting to read or write from the database.
.frmextension containing the table definition (for all storage engines).
.MYD(MYData) file which contains the data on it.
.MYI(MYIndex) file which contains the table’s indexes.
mytable.TRG. With the .TRN file, they represent all the trigger definitions.
mytable.TRN. With the .TRG file, they represent all the trigger definitions.
.ARMfile which contains the metadata of it.
.ARZfile which contains the data of it.
.CSMfile which contains the metadata of it.
.CSVfile which contains the data of it (which is a standard Comma Separated Value file).
.optextension in the database directory.
For general inquiries about our open source software and database management tools, please send us your question and someone will contact you.