Apply OS: macOS

Apply Navicat Product: All

Apply Navicat Version No.: Version 12.1

 

Navicat Object

Command Line

Automation

ProgramPath --batch-jobs BatchJobName

Backup
(MySQL, PostgreSQL, SQLite and MariaDB)

ProgramPath --backup ProfileName -u NavicatID -p ProjectName -t ConnectionType -c ConnectionName -d DatabaseName -s SchemaName

Data Synchronization

ProgramPath --data-synchronization ProfileName -t ConnectionType

Data Transfer

ProgramPath --data-transfer ProfileName -t ProfileType

Export Materialized View Result
(Oracle and PostgreSQL)

ProgramPath --export-mview ProfileName -u NavicatID -p ProjectName -t ConnectionType -c ConnectionName -d DatabaseName -s SchemaName

Export Query Result

ProgramPath --export-query ProfileName -u NavicatID -p ProjectName -t ConnectionType -c ConnectionName -d DatabaseName -s SchemaName

Export Table/Collection

ProgramPath --export ProfileName -u NavicatID -p ProjectName -t ConnectionType -c ConnectionName -d DatabaseName -s SchemaName

Export View Result

ProgramPath --export-view ProfileName -u NavicatID -p ProjectName -t ConnectionType -c ConnectionName -d DatabaseName -s SchemaName

Import

ProgramPath --import ProfileName -u NavicatID -p ProjectName -t ConnectionType -c ConnectionName -d DatabaseName -s SchemaName

MapReduce
(MongoDB)

ProgramPath --mapreduce ProfileName -u NavicatID -p ProjectName -t ConnectionType -c ConnectionName -d DatabaseName

MongoDump
(MongoDB)

ProgramPath --mongodump ProfileName

MongoExport
(MongoDB)

ProgramPath --mongoexport ProfileName

MongoImport
(MongoDB)

ProgramPath --mongoimport ProfileName

Query Execution

ProgramPath --query-execution QueryName -u NavicatID -p ProjectName -t ConnectionType -c ConnectionName -d DatabaseName -s SchemaName

Note:

ProgramPath - should be the path to the executable file inside: such as ./"Navicat Premium.app"/Contents/MacOS/"Navicat Premium"

NavicatID - if the connection stores in Navicat Cloud, Navicat ID is required, e.g. user@example.com

ProjectName - if the connection stores in Navicat Cloud, project name is required

ConnectionType - type of the connection: MySQL, Oracle, PostgreSQL, SQLite, MSSQL, MariaDB or MongoDB

ProfileType - type of the data transfer profile: MySQL, Oracle, PostgreSQL, SQLite, MSSQL, MariaDB, MongoDB or Premium

Example:

./"Navicat Premium.app"/Contents/MacOS/"Navicat Premium" -exportquery MyQueryExport1 -u test@navicat.com -p Project1 -t MySQL -c "MySQL 5.6" -d sakila

Have more questions?
Submit Ticket