O'Reilly logo

Mastering MariaDB by Federico Razzoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required