MySQL
  Home arrow MySQL arrow Page 2 - Using Navicat to Import Data into MySQL
Dev Shed Forums  
Administration  
AJAX  
Apache  
BrainDump  
DHTML  
Flash  
Java  
JavaScript  
Multimedia  
MySQL  
Oracle  
Perl  
PHP  
Practices  
Python  
Reviews  
Security  
Smartphone Development  
Style-Sheets  
Web Services  
XML  
Zend  
Zope  
Mobile Linux  
App Generation ROI  
IBM® developerWorks  
Forums Sitemap  
E-Commerce Hosting  
Linux Web Hosting  
Managed Hosting  
Small Business Hosting  
VPS Hosting  
Weekly Newsletter

 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid  
Request Media Kit
Contact Us  
Site Map  
Privacy Policy  
Support  
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
Google.com  
MYSQL

Using Navicat to Import Data into MySQL
By: Michael Mak
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: starstarstarstarstar / 28
    2004-04-19


    Table of Contents:
  • Using Navicat to Import Data into MySQL
  • Using Navicat's Import/Export Wizard
  • Other Features of Navicat
  • Conclusion

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      error-file:tidyout.log Del.ici.ous error-file:tidyout.log Digg
      error-file:tidyout.log Blink error-file:tidyout.log Simpy
      error-file:tidyout.log Google error-file:tidyout.log Spurl
      error-file:tidyout.log Y! MyWeb error-file:tidyout.log Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article

     
     
    ADVERTISEMENT


    Using Navicat to Import Data into MySQL - Using Navicat's Import/Export Wizard
    ( Page 2 of 4 )

    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
     

       

    MYSQL ARTICLES

    - MySQL Security Tips
    - Designing a MySQL Database: Tips and Techniq...
    - The Three Most Important MySQL Queries
    - Null and Empty Strings
    - MySQL Server Tuning Tips and Tricks
    - MySQL Query Optimizations and Schema Design
    - MySQL Benchmarking Tools and Utilities
    - MySQL Benchmarking Concepts and Strategies
    - Take Some Load off MySQL with MemCached
    - MySQL Table Prefix Changer Tool in PHP
    - Using the SIGNAL Statement for Error Handling
    - Error Handling Examples
    - Error Handling
    - Completing a Search Engine with MySQL and PH...
    - Paginating Result Sets for a Search Engine B...





    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 1 Hosted by Hostway
    For more Enterprise Application Development news, visit eWeek