Quick Start
Connect to MySQL
HTTP Tunnel
SSH Tunnel
Databases
Schema
Tables
Adding Fields and Choosing Data Types
Customising Fields
Primary Keys and Indexes
Filter Wizard
Foreign Keys
Foreign Keys Data Selection
Uniques and Checks
Rules and Triggers
Privileges
Import/Export
Function
View
Tablespace
Cast
Language
Aggregate
Conversion
Domain
Trigger Function
Operator
Operator Class
Sequence
Type
Queries
Visual Query Builder
Data
Manage Users
Backup
Data Transfer
Schedule
Server Monitor
Data Synchronization
Structure Synchronization
Console
Virtual Grouping
Maintaining your databases/tables
Preferences
General
Tabs
Tables
Queries
  Working with Databases
 

Create a database
To create a new database, control-click the server where the database should be created in the Server Navigator, click New Database in the Connection Menu.

After you create a new database, you must perform additional steps to define the tables, queries and reports that will make up your database.

Open a database
After connecting to the server, Double click on the preferred database to show all the tables, queries and backups associated with the database.

Rename a database
To rename a database, control-click on the database in the Server Navigator and select and select Database Properties. Use Database Name edit box to rename it.

Delete a database
To delete a database, select the database in the Server Navigator and click Drop Database in the connection menu. A confirmation dialog will prompt you before deleting the database.

NOTE: Be very careful when deleting a database, the operation is irreversible.

Copy a database
You can copy a database from one server to another or to the same server under a different database name by using Navicat's Data Transfer function.

Move a database
You can move a database from one server to another by copying the database to where you want it and then delete the original one.

Maintain a database
Please visit Maintaining your Database/Tables for details