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

时间:2021-09-02 03:57:00

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

  • 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