Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

sql
arz
arm
sql extensions

.ARZ file vs. .ARM file in MySQL

Educative Answers Team

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.

svg viewer

RELATED TAGS

sql
arz
arm
sql extensions
Copyright ©2022 Educative, Inc. All rights reserved
RELATED COURSES

View all Courses

Keep Exploring