Download Untitled

Transcript
Navicat for MySQL
Start Navicat from command line:
Navicat
Command Lines
Objects
Backup
File Extensions
Navicat.exe /backup ConnectionName DatabaseName
Backup Server Navicat.exe /backupserver ConnectionName
compressed
Backup
Navicat.exe /backupdatabase ConnectionName
(.psc),
Database
DatabaseName
uncompressed
Navicat.exe /backupprofile ConnectionName
(.psb)
Backup Profile
Import
Export Table
DatabaseName ProfileName
Navicat.exe /import ConnectionName DatabaseName
ProfileName
Navicat.exe /export ConnectionName DatabaseName
ProfileName
.npi
.npe
Export View
Navicat.exe /exportview ConnectionName DatabaseName
Result
ProfileName
Export Query
Navicat.exe /exportquery ConnectionName
Result
DatabaseName ProfileName
Query
Navicat.exe /query ConnectionName DatabaseName
Execution
QueryName
Data Transfer
Navicat.exe /datatransfer ProfileName
.npt
Navicat.exe /datasync ProfileName
.npd
Navicat.exe /batchjob BatchJobName
.npj
Data
Synchronization
Batch Jobs
Print Report
Navicat.exe /report ConnectionName DatabaseName
ReportName Param1 Param2
.npev
.npeq
.sql
.rtm
Note:
Param1 - file type: pdf, htmlfile or excelfile
Param2 - printer name or target file path, e.g. C:\Users\user1\Desktop\test1.pdf
Navicat Win
1211