5.6数据迁移到5.7

5.6数据迁移到5.71、数据库备份mysqldump -uroot -pruan -A --master-data2 --single-transaction -R -E --triggers /tmp/full.sql2、发送文件到5.7主机scp /tmp/full.sql 10.0.0.200:/data/3、mysql会话窗口source /data/full.sql4、版本不兼容mysql_upgrade -uroot -pruan (如报错flush privileges 刷新权限表)在执行命令时候报如下错误Got error: 2002: Can’t connect to local MySQL server through socket ‘/data/mysql/mysql.sock’ (2) when trying to connect找到正确的套接字的路径[rootlocalhost ~]# netstat -ln | grep mysqlunix 2 [ ACC ] STREAM LISTENING 2447213870 /data/mysql/data/mysql.sock再运行命令mysql_upgrade --socket/data/mysql/data/mysql.sock -uroot -pruan