mysql远程连接

mysql -h xxx.com -P 3306 -u root -pxxxx

建立

create database rxxx;

alter database rmanga CHARACTER SET utf8mb4;

use rxxx;

show variables like ‘character_set_database’;

导入

use database;

source db-rxxx-2019102513.sql;

导出

/usr/local/mysql/bin/mysqldump -u root -p -h xxx.com rxxx | gzip > rxxx.sql.gz