Installing on Windows
  Getting Started
  User Privileges
  Creating a Database
  Import / Export

  Download Manual
  Books
 
by Paul DuBois
ISBN: 0735712123
   
 
by Paul DuBois
ISBN: 0596001452


Importing and Exporting from MySQL  
 

Importing into MySQL from a file:
C :\mysql\bin> mysqlimport [options] dbname filename.txt       [See in MySQL Manual 4.8.7]
or
mysql> use dbname;

mysql> LOAD DATA INFILE 'filename.txt'
       [See in MySQL Manual 6.4.9]
        -> [REPLACE | INGNORE]

        -> INTO TABLE table_name

        -> [FIELDS
        ->   [TERMINATED BY '\t']
        ->   [[OPTONALLY] ENCLOSED BY ' " ']
        ->   [ESCAPED BY '\n']]
        -> [INGORDE num LINES];


Exporting from MySQL to a file:
C :\mysql\bin> mysqldump [options] dbname [tables] > filename.txt        [See in MySQL Manual 4.8.5]
or
mysql> use dbname;

mysql> SELECT *
                            [See in MySQL Manual 6.4.1]
        -> INTO OUTFILE 'filename.txt'

        -> [FIELDS
        ->   [TERMINATED BY '\t']
        ->   [[OPTONALLY] ENCLOSED BY ' " ']
        ->   [ESCAPED BY '\n']]

        -> FROM table_name


Example:
Creating a backup of a database and importing a backup file.
Making a backup:
C :\mysql\bin> mysqldump --opt visualtech_db > visualtech_backup.sql  
Inserting a backup

C :\mysql\bin> mysql -u root -p visualtech_cb < visualtech_backup.sql

 

 
 

Copyright 2002 VisualTech Components. All Rights Reserved.