mysqldbimport(1) - Linux man page

Name

Synopsis

Description

Options

--version

show program's version number and exit

--help

display a help message and exit

--server=SERVER

connection information for the server in the form: <user>[:<password>]@<host>[:<port>][:<socket>] or <login-path>[:<port>][:<socket>].

-f FORMAT, --format=FORMAT

the input file format in either sql (default), grid, tab, csv, or vertical format

-i IMPORT_TYPE, --import=IMPORT_TYPE

control the import of either 'data' = only the table data for the tables in the database list, 'definitions' = import only the definitions for the objects in the database list, or 'both' = import the metadata followed by the data (default: import definitions)

-d, --drop-first

drop database before importing.

-b, --bulk-insert

use bulk insert statements for data (default:False)

-h, --no-headers

files do not contain column headers

--dryrun

import the files and generate the statements but do not execute them - useful for testing file validity

--skip-blobs

do not import blob data.

--skip-rpl

do not execute replication commands.

--skip-gtid

do not execute the GTID_PURGED statements.

--skip=SKIP_OBJECTS

specify objects to skip in the operation in the form of a comma-separated list (no spaces). Valid values = tables, views, triggers, procedures, functions, events, grants, data, create_db

-v, --verbose

control how much information is displayed. e.g., -v = verbose, -vv = more verbose, -vvv = debug

-q, --quiet

turn off all messages for quiet execution.

--new-storage-engine=NEW_ENGINE

change all tables to use this storage engine if storage engine exists on the destination.

--default-storage-engine=DEF_ENGINE

change all tables to use this storage engine if the original storage engine does not exist on the destination.

Copyright