Mastering MariaDB

Delimited text backups

A backup of a single table can be a delimited text file: a human-readable text file in which the column values are separated by a specific character. The most common example is the CSV format, where the values are separated by a comma. MariaDB supports the following ways to create text-delimited files:

• The mysqldump command with the --tab option
• The SELECT … INTO OUTFILE command
• The CSV storage engine
• The CONNECT storage engine

MariaDB also supports the following methods to restore a text limited backup:

• The mysqlimport command
• The LOAD DATA INFILE command
• The CSV storage engine
• The CONNECT storage engine

The --tab option of the mysqldump command

The mysqldump command, when invoked with the --tab option, produces two files for each ...