Using Navicat to Import Data into MySQL - Other Features of Navicat

(Page 3 of 4 )

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.

Next: Conclusion >>
 

More MySQL Articles
More By Michael Mak

Comments On: Using Navicat to Import Data into MySQL

· michael now i think it is sqlyog is compatible, now a days i am using for my mysql...    · hey guys, i am glad to tell about sqlyog which i found best to play around with. its...   >>> Post your comment now!