Home arrow MySQL arrow Page 3 - Importing Data into MySQL with Navicat
MYSQL

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

Importing Data into MySQL with Navicat - Using Navicat's Import/Export Wizard
(Page 3 of 5 )

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.

blog comments powered by Disqus
MYSQL ARTICLES

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

Developer Shed Affiliates

 




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