mysql命令
- 查看mysql版本:mysql -V
- 备份表数据:
- mysqldump -h 10.222.106.26 -P 3992 -uuser_qzone -p AP_Admin Tbl_AdUser>aduser.sql;
- SELECT * INTO OUTFILE ‘aduser.txt’ FROM Tbl_AdUser;
- mysql -h10.222.106.26 -uuser_qzone -P3992 -p --default-character-set=utf8 AP_Admin -e ‘select * from CompanyChannelManagerPolicyList’ > aduser.txt
- 列多的时候:select * from CompanyChannelManagerPolicyList \G;
- 设置编码格式
- set names latin1;
- select * from CompanyChannelManagerPolicyList;
- mysql -h192.222.106.26 -uusername -P3992 -p