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:
mysqldumpcommand with the
SELECT … INTO OUTFILEcommand
MariaDB also supports the following methods to restore a text limited backup:
LOAD DATA INFILEcommand
mysqldump command, when invoked with the
--tab option, produces two files for each ...