DATA IMPORT & EXPORT

  Data Import & Export

 

1. MySQL

 

data export:
%MYSQL_HOME%/bin> mysqldump [options] database [tables]

 

eg.  mysqldump --opt database_name > backupfile.sql

 

data import:
There are two commands for importing, mysql and mysqlimport.
The first one import msql dump file into a database.
The second one import data from a txt file into a table. The txt filename and the table name should be the same.

 

eg. (1) mysql> mysql database_name < backupfile.sql
     (2) %MYSQL_HOME%/bin> mysqlimport database_name tablename.txt