当前位置:首页 > 数据库 > 正文

解决阿里云数据导入自建数据库过程中,导入出错的问题

2020-03-01 数据库

解决阿里云数据导入自建数据库过程中,导入出错的问题

  • mysql配置改进:vim /etc/my/cnf
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    secure_file_priv=‘‘
    max_allowed_packet = 10M
    character-set-server = utf8mb4
    collation-server = utf8mb4_general_ci
    #collation-server = utf8mb4_unicode_ci
    character-set-client-handshake = FALSE
    character-set-server = utf8mb4
    init_connect=’SET NAMES utf8mb4’
    [client]
    default-character-set = utf8mb4
    [mysql]
    default-character-set = utf8mb4

温馨提示: 本文由Jm博客推荐,转载请保留链接: https://www.jmwww.net/SQL/21582.html