项目从MYSQL迁移至MARIADB教程
准备数据库(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;