Home arrow MySQL arrow Page 3 - Using Navicat to Import Data into MySQL

Other Features of Navicat&toc - MySQL

In today's article Michael takes a look at using Navicat (a MySQL management tool) to quickly and easily import/export data to and from MySQL.

  1. Using Navicat to Import Data into MySQL
  2. Using Navicat's Import/Export Wizard
  3. Other Features of Navicat
  4. Conclusion
By: Michael Mak
Rating: starstarstarstarstar / 30
April 19, 2004

print this article



Some of Navicats key features are listed below:

  • Supports multiple connections for local or remote MySQL servers.
  • Browse databases, modify your data, create or delete databases, tables, indexes and users accounts.
  • Create or run SQL queries with the visual query builder.
  • Create reports with the visual report builder. Reports can be saved as an archive file (.raf) for backup and increased portability.
  • Manage user privileges [security configuration].
  • Backup/restore your database. The new Schedule Backup feature is used to create a new schedule that will backup your data.
  • Data Transfer. Navicat supports transfering databases from one MySQL server to another MySQL server (1. Local to Remote , 2. Remote to Remote, 3. Remote to Local).
  • Import/export data. The import and export wizard supports 18 formats including MS Access, MS Excel, XML, PDF and TXT.

Navicat Tips

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

The localhost connection setting would look something like this:

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

Before you establish a local connection between Navicat and your local MySQL server, use the launcher program to start your local MySQL server. You can also use WinMySQLAdmin to start your MySQL server (c:mysql.inwinmysqladmin.exe).

After MySQL is installed, by default, it only allows "localhost" connections. Therefore, most server-side scripts (e.g. phpMyAdmin) can easily connect with the local database on the same server. You can use Telnet or an SSH client to manage your remote server because it's also a localhost connection.

Any client PC/s will be blocked by the remote MySQL server until the user privileges have been configured.

A remote connections settings would look like this:

Host : IP address of remote MySQL server
Username : Your_username (username is 'root' if you just installed MySQL)
Password : Your_password (Emtpy value if you just installed MySQL)
Port : 3306 (default)

NOTE: Navicat can access your remote MySQL server no matter if it's running on a Linux, Unix, Mac, Windows platform.

>>> More MySQL Articles          >>> More By Michael Mak

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates


Dev Shed Tutorial Topics: