线上到开发
mysqldump -uprsc -p20171206 sik > weChatGroupStatistics.sql (导出)
mysql -h47.96.4.221 -umysql -psi2017 sik < weChatGroupStatistics.sql (导入)
开发到本地
mysqldump -h47.96.4.221 -umysql -psk2017 sik > weChatGroupStatistics.sql
mysql -uroot -pmysql sik < weChatGroupStatistics.sql
转载:https://blog.csdn.net/youngys123/article/details/79804611