MySQL메뉴의 Tools - Export/Import를 Query로 실행 -- MySQL



Mysql Data 만 Export

 

select *into outfile "/temp/file.dump" fields terminated by '\t' optionallyenclosed by '"' lines terminated by '\n' from [dababase.tablename];

 

 

Mysql DataImport


LOAD DATAINFILE 'file.dump' INTO TABLE [dababase.tablename] FIELDS TERMINATED BY '\t'OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';


출처 : http://blog.naver.com/dresstowin?Redirect=Log&logNo=50109664456


덧글

댓글 입력 영역