Linux Commands

Apply OS: Linux

Apply Navicat Product: All

Apply Navicat Version No.: Version 11.2 or above

 

Navicat Objects

Server Type

Command Lines

Backup

MySQL, PostgreSQL, SQLite and MariaDB

start_navicat -backup [ProfileName] -u NavicatID -p ProjectName -t ConnectionType -c ConnectionName -d DatabaseName -s SchemaName

Import

All

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

Export Table

All

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

Export View Result

All

start_navicat -exportview ProfileName -u NavicatID -p ProjectName -t ConnectionType -c ConnectionName -d DatabaseName -s SchemaName

Export Materialized View Result

Oracle and PostgreSQL

start_navicat -exportmview ProfileName -u NavicatID -p ProjectName -t ConnectionType -c ConnectionName -d DatabaseName -s SchemaName

Export Query Result

All

start_navicat -exportquery ProfileName -u NavicatID -p ProjectName -t ConnectionType -c ConnectionName -d DatabaseName -s SchemaName

Query Execution

All

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

Data Transfer

All

start_navicat -datatransfer ProfileName -t ProfileType

Data Synchronization

All

start_navicat -datasync ProfileName -t ConnectionType

Batch Jobs

All

start_navicat -batchjob BatchJobName

Note:

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 or MariaDB

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

Example:

start_navicat -exportquery MyQueryExport1 -u test@navicat.com -p Project1 -t MySQL -c "MySQL 5.6" -d sakila

Have more questions? Submit Ticket.
Have more questions? Submit a request

0 Comments

Article is closed for comments.