MARIADB-IMPORT(1) MariaDB Database System MARIADB-IMPORT(1) (NAME) mariadb-import - (SYNOPSIS) mariadb-import [options] db_name textfile1 ... (DESCRIPTION) mariadb-import SQL LOAD DATA INFILE . mariadb-import LOAD DATA INFILE . mariadb-import : shell> mariadb-import [options] db_name textfile1 [textfile2 ...] mariadb-import . patient.txt, patient.text, patient patient . mariadb-import [mariadb-import] [client] . mariadb-import . o --help, -? . o --character-sets-dir=path (character sets). o --columns=column_list, -c column_list . . o --compress, -C . o --debug[=debug_options], -# [debug_options] (debug log). debug_options 'd:t:o,file_name'. 'd:t:o' . o --debug-check . o --debug-info . o --default-auth=plugin_name . o --default-character-set=charset_name charset_name . o --defaults-extra-file=filename filename . . o --defaults-file=filename filename . . o --delete, -d . o --fields-terminated-by=..., --fields-enclosed-by=..., --fields-optionally-enclosed-by=..., --fields-escaped-by=... LOAD DATA INFILE . o --force, -f . . --force mariadb-import . o --host=host_name, -h host_name MariaDB . localhost . o --ignore, -i --replace . o --ignore-foreign-keys, -k (foreign keys) . o --ignore-lines=N N . o --innodb-optimize-keys ( InnoDB). --skip- innodb-optimize-keys . o --lines-terminated-by=... LOAD DATA INFILE . carriage return/linefeed --lines-terminated-by="\r\n" . ( ). o --local, -L . o --lock-tables, -l . . o --low-priority LOW_PRIORITY . ( MyISAM MEMORY MERGE). o --no-defaults . . o --parallel=N, -j N LOAD DATA . --use-threads . o --password[=password], -p[password] . (-p) . password --password -p mariadb-import . . . o --pipe, -W named pipe. named-pipe . o --plugin-dir=name . o --port=port_num, -P port_num TCP/IP . --protocol=tcp . o --protocol={TCP|SOCKET|PIPE|MEMORY} . . o --print-defaults . . o --replace, -r --replace --ignore (unique key) . --replace . --ignore . . o --silent, -s . . o --socket=path, -S path localhost named pipe . --protocol=socket --protocol=pipe . o --ssl SSL ( ). --skip-ssl. o --ssl-ca=name CA PEM ( OpenSSL --ssl ). o --ssl-capath=name CA ( OpenSSL --ssl ). o --ssl-cert=name X509 PEM ( OpenSSL --ssl ). o --ssl-cipher=name SSL ( OpenSSL --ssl ). o --ssl-key=name X509 PEM ( OpenSSL --ssl ). o --ssl-crl=name ( OpenSSL --ssl ). o --ssl-crlpath=name ( OpenSSL --ssl ). o --ssl-verify-server-cert << >> (Common Name) . . o --user=user_name, -u user_name MariaDB . o --use-threads=N N (thread). -j --parallel=num. o --verbose, -v (verbose). . o --version, -V . mariadb-import : shell> mariadb -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test shell> ed a 100 Max Sydow 101 Count Dracula . w imptest.txt 32 q shell> od -c imptest.txt 0000000 1 0 0 \t M a x S y d o w \n 1 0 0000020 1 \t C o u n t D r a c u l a \n 0000040 shell> mariadb-import --local test imptest.txt test.imptest: Records: 2 Deleted: 0 Skipped: 0 Warnings: 0 shell> mariadb -e 'SELECT * FROM imptest' test +------+---------------+ | id | n | +------+---------------+ | 100 | Max Sydow | | 101 | Count Dracula | +------+---------------+ (COPYRIGHT) Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc., 2010-2025 MariaDB Foundation (GNU General Public License) / . . . Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA http://www.gnu.org/licenses . (SEE ALSO) MariaDB https://mariadb.com/docs . (AUTHOR) MariaDB (http://www.mariadb.org). MariaDB 11.8 10 February 2025 MARIADB-IMPORT(1)