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
mysqldumpcommand with the--taboptionThe
SELECT … INTO OUTFILEcommandThe
CSVstorage engineThe
CONNECTstorage engine
MariaDB also supports the following methods to restore a text limited backup:
The
mysqlimportcommandThe
LOAD DATA INFILEcommandThe
CSVstorage engineThe
CONNECTstorage engine
The
mysqldump command, when invoked with the --tab option, produces two files for each dumped table. The name of these files is the name of the original table, followed by an extension. One file has a .sql extension, and it contains the CREATE TABLE statement that is necessary to recreate the empty table. Of course, this file needs...