mariadb my.ini及备份方法

mariadb my.ini及备份方法

一、配置my.ini

[mysqld]
datadir=C:/Program Files/MariaDB 10.9/data
port=3307
innodb_buffer_pool_size=128M

#binlog_format=“STATEMENT”
#binlog_format=“ROW”
#binlog_format=“MIXED”

[client]
port=3307
plugin-dir=C:\Program Files\MariaDB 10.9/lib/plugin

二、备份方法:

C:\Program Files\MariaDB 10.9\bin>mysqldump --user=root --password --databases yhjdb >d:\maridb.sql
Enter password: ****