homehome previousprevious nextnext
 
Advanced Settings

Customize connection options according to your needs. The detailed description is given below:

Settings Save Path
When a new connection being established, Navicat MySQL will create a subfolder under the Settings Save Path. Most files are stored within this subfolder:

Navicat Objects
File Extensions
Query .sql
Export Query Result Profile .npeq
Export View Result Profile .npev
Backup

compressed (.psc), uncompressed (.psb)

Backup Profile

.npb

Report

.rtm

Import Wizard Profile

.npi

Export Wizard Profile

.npe

Other files are located in the profiles directory, which is a sub-directory of your Navicat installation folder, e.g. C:\Program Files\PremiumSoft\Navicat MySQL\profiles.

Other Profiles
File Extensions
Data Transfer .npt
Data Synchronization .npd
Structure Synchronization .nps
Batch Job

.npj

Virtual Grouping

vgroup.xml - stores how the objects are categorized.

Hint: All your connection settings are stored in registry.

See also:
Log Files

Encoding
Choose a codepage to communicate with MySQL Server while MySQL character set not being employed.

Timeout reconnection (sec)
This option allows you to keep the connection with the server alive by pinging it. You can set the period between pings in the edit field.

Use MySQL character set
This option should be enabled if employing MySQL 4.1 or above.

Use Compression
This option allows you to use compression protocol. It is used if both client and server support zlib compression, and the client requests compression.

Auto Connect
With this option on, Navicat MySQL automatically open connection with the registered database at application startup.


See also:
Database Management

 

Copyright 1999 - 2007. PremiumSoft TM CyberTech Ltd All rights reserved
MySQL TM is a trademark of MySQL AB in the United States and other countries.