Mysql Select Into File - Mysql 파일 백업

MySQL Table  을 다른 시스템을 이관하는경우 테이블내용을  Excel  이나   csv format File 로 내려 받으면 된다.
아래가 간단한 예제임.

mysql> select * into outfile "/outputpath/outputname.xls"
              fields terminated by '\t'
              lines terminated by '\n' from sourceDb.sourceTable;

Query OK, 48561 rows affected (0.08 sec)

mysql> select * into outfile "/outputpath/outputname.csv"
              fields terminated by ','
              lines terminated by '\n' from sourceDb.sourceTable;

Query OK, 48561 rows affected (0.09 sec)