问题:怎么将mysql表数据导出
解答:
方法1:执行sql导出
mysql -h $IP -u $USERNAME -p$PASSWORD -D$DB_NAME<$SQL -vvv >> $LOG_FILE
方法2:导出宿主机的本地目录文件
mysqldump -h $IP -u $USERNAME -p$PASSWORD $DATABASE_NAME $TABLE_NAME > $OUTPUT_FILENAME
方法3:
mysql -h $IP -u $USERNAME -p$PASSWORD -e "select $COLUMNAME1,$COLUMNAME2 from $DATABASE_NAME.$TABLE_NAME" > dump_autotest.txt
方法4:导出到mysql服务器的路径
select report,testname INTO OUTFILE '/var/lib/mysql-files/dump.txt'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
from autotest;
方法5:跨mysql服务器之间导数据
mysqldump --host=192.168.80.137 -uroot -proot -C --databases test |mysql --host=192.168.80.133 -uroot -proot test
mysql导出数据出现问题,tab自动转义为’\t’