隨手記mysql_MySQL

mysql> SELECT * FROM tutorials_tbl -> INTO OUTFILE '/tmp/tutorials.txt';#導出csv格式mysql> SELECT * FROM passwd INTO OUTFILE '/tmp/tutorials.txt' -> FIELDS TERMINATED BY ',' ENCLOSED BY '"' -> LINES TERMINATED BY '/r/n';

#導出$ mysqldump -u root -p TUTORIALS tutorials_tbl > dump.txt#導入$ mysql -u root -p database_name < dump.txt#load datamysql> LOAD DATA LOCAL INFILE 'dump.txt' INTO TABLE mytbl;mysql> LOAD DATA LOCAL INFILE 'dump.txt' INTO TABLE mytbl -> FIELDS TERMINATED BY ':' -> LINES TERMINATED BY '/r/n';mysql>LOAD DATA LOCAL INFILE 'dump.txt' -> INTO TABLE mytbl (b, c, a);$ mysqlimport -u root -p --local database_name dump.txt

$ mysqldump -u root -p database_name / | mysql -h other-host.com database_name