macOS Commands

updated at 

Apply OS: macOS

Apply Navicat Product: All

Apply Navicat Version No.: Version 12

 

Navicat Objects

Server Type

Command Lines

Backup

MySQL, PostgreSQL, SQLite and MariaDB

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

Restore Backup

MySQL, PostgreSQL, SQLite and MariaDB

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

Import

All

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

Export Table

All

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

Export View Result

All

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

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

All

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

Query Execution

All

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

Data Transfer

All

ProgramPath --data-transfer ProfileName -t ProfileType

Data Synchronization

All

ProgramPath --data-synchronization ProfileName -t ConnectionType

Batch Jobs

All

ProgramPath --batch-jobs BatchJobName

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

ProfileType - type of the data transfer profile: MySQL, Oracle, PostgreSQL, SQLite, MSSQL, MariaDB 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

Related articles

Have more questions?
Submit Ticket