导出数据库
mysqldump -uroot -p123456 subscription > subscription.sql
导出数据库表
mysqldump -uroot -p123456 subscription client_upload_install_event > client_upload_install_event.sql
导出表 条件过滤
mysqldump -uroot -p123456 subscription client_upload_install_event --where=" package_name = 'com.dailyhoroscope.facesecret' " > client_upload_install_event.sql
导出多张表
mysqldump -uroot -p123456 subscription client_upload_install_event advertising_costs new_report_detail_v2 > subscription.sql
导入数据,登录之后
source /root/4.sql;
导入数据,不需要登录 忽略错误
mysql -uroot -p123456 -f subscription < /root/5.sql