2014. 1. 13. 16:54
Export DB data
SELECT (column,...] INTO OUTFILE '/tmp/backUpDB.csv' FROM [table name];
Import DB data
LOAD DATA LOCAL INFILE '/tmp/backUpDB.csv' INTO TABLE [table name];
ps data에 탭이 있을경우 조건식을 줘야함.
Export DB data
Import DB data
ps data에 탭이 있을경우 조건식을 줘야함.