好资源导航 » 文章资讯 » 项目从MYSQL迁移至MARIADB教程

项目从MYSQL迁移至MARIADB教程

2024-02-17 10:37:03 94

准备数据库(MySQL),若已有MySQL,可忽略.

buildMySQLtable;

连接MySQL;

mysql-uroot-p

创建数据表;

mysql>createdatabasedemo;

mysql>usedemo;

mysql>createtablepet(namevarchar(30),ownervarchar(30),speciesvarchar(20),sexchar(1));

添加数据表内容;

mysql>insertintopetvalues('brandon','Jack','puddle','m'),('dixie','Danny','chihuahua','f');

exit(); ----退出MySQL

backupMySQL;

前情提示,启用二进制;

备份数据表;备份my.cnf;

$mysqldump--all-databases--user=root--password--master-data>backupdb.sql

$sudocp/etc/mysql/my.cnf/opt/my.cnf.bak

delMySQL;

停止MySQL服务;

$sudoservicemysqlstop//RHEL6

$sudosystemctlstopmysql//RHEL7

$sudo/etc/init.d/mysqlstop//RHEL6

移除MySQL配置及文件;

$sudoyumremovemysql*mysql-servermysql-develmysql-libs

$sudorm-rf/var/lib/mysql

buildmariadb;

安装mariadb;以及相关依赖包;

$sudovi/etc/yum.repos.d/MariaDB.repo //创建自定义的yum源

....................................... //以下为文件内容

[mariadb]

name=MariaDB

baseurl=http://yum.mariadb.org/5.5/centos7-amd64

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

.......................................

$sudoyuminstallMariaDB-serverMariaDB-client//安装MariaDB

恢复my.cnf文件;

$sudocp/opt/my.cnf /etc/mysql/

启动mariadb;

$sudoservicemariadbstart

$sudosystemctlstartmariadb

$sudo/etc/init.d/mariadbstart

MySQL==>>MARIADB;

将数据表导入到mariadb中;

$mysql-uroot-p

出现一下内容,表示登录成功;恭喜你;

$mysql-uroot-p

......................................//以下为sql命令

MariaDB[(none)]>showdatabases;

MariaDB[(none)]>usetest01;

MariaDB[test01]>select*frompet;