MYSQL TUTORIALS - MySQL Database Import
MySQL Database Import
ADVERTISEMENTS
Importing Data with LOAD DATA:
mysql> LOAD DATA LOCAL INFILE 'dump.txt' INTO TABLE mytbl;ADVERTISEMENTS
mysql> LOAD DATA LOCAL INFILE 'dump.txt' INTO TABLE mytbl -> FIELDS TERMINATED BY ':' -> LINES TERMINATED BY '\r\n';ADVERTISEMENTS
mysql> LOAD DATA LOCAL INFILE 'dump.txt' -> INTO TABLE mytbl (b, c, a);Importing Data with mysqlimport
$ mysqlimport -u root -p --local database_name dump.txt password *****
$ mysqlimport -u root -p --local --fields-terminated-by=":" \ --lines-terminated-by="\r\n" database_name dump.txt password *****
$ mysqlimport -u root -p --local --columns=b,c,a \ database_name dump.txt password *****