Home arrow MySQL arrow Page 4 - Importing Data into MySQL with Navicat

Importing Data into MySQL with Navicat

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.

Author Info:
By: Michael Mak
Rating: 4 stars4 stars4 stars4 stars4 stars / 28
September 13, 2003
  1. · Importing Data into MySQL with Navicat
  2. · Overview
  3. · Using Navicat's Import/Export Wizard
  4. · Other Features of Navicat
  5. · Conclusion

print this article

Importing Data into MySQL with Navicat - Other Features of Navicat
(Page 4 of 5 )

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\bin\winmysqladmin.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 its running on a Linux, Unix, Mac, Windows platform.

blog comments powered by Disqus

- MySQL and BLOBs
- Two Lessons in ASP and MySQL
- Lord Of The Strings Part 2
- Lord Of The Strings Part 1
- Importing Data into MySQL with Navicat
- Building a Sustainable Web Site
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- PhpED 3.2 More Features Than You Can Poke ...
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- Security and Sessions in PHP
- Setup Your Personal Reminder System Using PHP
- Create a IP-Country Database Using PERL and ...
- Developing a Dynamic Document Search in PHP ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials