.ARZ file vs. .ARM file in MySQL

Whenever MySQL database installation is done, all the database related data and metadata are stored in one folder. There are various extensions of files stored in this folder (e.g., .frm, myi, .arz, .arm, etc.), but in this shot, we will look at the .arz and .arm extensions.

.ARM file

Files of this extension happen due to a mysqlbackup command of the MySQL Enterprise Backup product. This extension stores the metadataData about data in a database. For a relational database, metadata is information about data, accessibility, storage, programs, or any information in the schema for ARCHIVE tables and works in contrast with files having .arz extension.

.ARZ file

Files of this extension result from a mysqlbackup command of the MySQL Enterprise Backup product. This extension stores the data for ARCHIVE tables. It works in contrast with files that have the .arz extension. In terms of a relational database, all the organized content in tables and columns with all their specific constraints (e.g., foreign key, primary key, data type, etc.) are referred to as data.