1. Click the Tables tab

2. Select the table which you want to export data. Click Export Wizard at the Database Window

OR

Right-click anywhere in the Database Window and select Export Wizard

3. An Export Wizard dialog box will be shown.

4. Please select which data format you want and click OK button to proceed

Some of the Navicat key features are listed below:

1.) Support Multiple Connections for local or remote MySQL servers

2.) Browse databases, Modify your data, Create and delete databases, tables, indexes and users accounts

3.) Create or Run SQL queries with visual query builder

4.) Create reports with visual report builder, Reports can be saved as an archive file (.raf) for backup and increased portability.

5.) Manage user privileges [security configuration]

6.) Backup/Restore your database, The new Schedule Backup feature is used to create a new schedule that will backup your data.

7.) Data Transfer - Support transfer databases from one MySQL server to another MySQL server (1. Local to Remote , 2. Remote to Remote, 3. Remote to Local)

8.) Import/Export data - The Import and Export Wizard would help you to import/export data. It supports up to 18 most popular formats including MS Access, MS Excel, XML, PDF and TXT.

Localhost connection setting

If you installed MySQL database on your local PC (Download URL: http://www.mysql.com/downloads/mysql-3.23.html ), the default username is "root" and password is empty.

Localhost connection setting is similiar as following :

Host : localhost
Username : root
Password : (empty)
Port : 3306 (default)