mysql 迁移 mariadb_MySQL迁移mariaDB

1.初始化

进入bin目录下执行

mysql_install_db

2.修改配置文件

进入data目录下,修改my.ini

[mysqld]

basedir=D:\Application\mariadb-10.4.12-winx64

datadir=D:\Application\mariadb-10.4.12-winx64\data

port=3307

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

default_storage_engine=innodb

max_connections=100

query_cache_size=0

innodb_strict_mode = 0

innodb_file_per_table=1

innodb_buffer_pool_size=2047M

innodb_log_file_size=50M

max_allowed_packet = 500M

character-set-server=utf8

log-bin=D:\Application\mariadb-10.4.12-winx64\log\mysql-bin

log_bin_index=D:\Application\mariadb-10.4.12-winx64\log\mysql-bin.index

log_bin_trust_function_creators=1

binlog_format=mixed

expire_logs_days=