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

Using Navicat's Import/Export Wizard&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.

TABLE OF CONTENTS:
  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
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

To import data to a table using the Import Wizard:

  1. Click the tables tab
  2. If you have an existing table to which you want to import data, select the table. Otherwise, do not select any table.
  3. Click Import Wizard at the Database Window, or, right-click anywhere in the Database Window and select Import Wizard.
  4. An Import Wizard dialog box will be shown. Depending on the import data format, you should follow several steps to complete the import process.

Here are the steps for importing from a text file:

  1. Choose which import data format you would like.
  2. Locate a file containing data to import.
  3. Select the appropriate delimiter (for text files only).
  4. You can define some additional options for source
  5. The wizard has made some guesses about where your field breaks occur. If they are incorrect, you can make adjustments in this step.

    NOTE: If the import data format is text and you have selected "fixed width" in step 3, you can set field breaks in this step.
  6. The wizard will make some guesses on your table structure and you can make adjustments.
  7. You can define the field mappings. Set mappings to specify the correspondence between fields in the source and fields in the destination.
  8. Check your data before importing.
  9. Select a desired import mode.
  10. Click the execute button to start importing data.

To export data using the Export Wizard:

  1. Click the tables tab.
  2. Select the table that you want to export data from. 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. Select which data format you want and click OK button to proceed.


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

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

MYSQL ARTICLES

- 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: