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

-- MySQL

어린왕자악꿍 2012. 7. 30. 16:45

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';