niva mysql_CentOS下,MySQL数据库的导出导入功能验证

导读

正文

问题起源:MysqL创建集群需要maria-galera版本

而现在安装的数据库中已经有了一些数据,不想再重新输入数据。

删除数据库,数据导出导入功能

2.1.1 删除StorOS的数据库

StorOS自带的数据库:

[root@localhost etc]# rpm -aq |grep maria

mariadb-libs-5.5.35-3.el7.x86_64

mariadb-5.5.35-3.el7.x86_64

mariadb-server-5.5.35-3.el7.x86_64

mariadb-devel-5.5.35-3.el7.x86_64

# rpm -e --nodeps mariadb-libs mariadbmariadb-server mariadb-devel

[root@localhost etc]# rpm -aq |grep maria

[root@localhost etc]#

清理文件:

# rm /usr/share/MysqL/ -rf

2.1.2 安装非galera版本的数据库

yum install mariadbmariadb-server MysqL-python

[root@localhost yum.repos.d]# rpm -aq |grepmaria

mariadb-libs-5.5.44-2.el7.centos.x86_64

mariadb-server-5.5.44-2.el7.centos.x86_64

mariadb-5.5.44-2.el7.centos.x86_64

启动:

# systemctlenable mariadb.service

# systemctl startmariadb.service

2.1.3 创建数据表

创建密码:

#MysqL_secure_installation

Root密码为1,其他全部选择Y

#MysqL -uroot -p1

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 10

Server version: 5.5.44-MariaDB MariaDBServer

Copyright (c) 2000,2015,Oracle,MariaDBCorporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' toclear the current input statement.

创建数据库表:nova

MysqL -u root –p

CREATE DATABASE nova;

GRANT ALL PRIVILEGES ON nova.* TO'nova'@'localhost' IDENTIFIED BY '1';

GRANT ALL PRIVILEGES ON nova.* TO'nova'@'%' IDENTIFIED BY '1';

FLUSH PRIVILEGES;

MariaDB [(none)]> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| nova |

| performance_schema |

+--------------------+

4 rows in set (0.01 sec)

这里只有nova是新增的,其他都是自带的。

在nova中创建一些表:

MariaDB [(none)]> use nova;

MariaDB [nova]> create table compute(idint(4),name char(20));

MariaDB [nova]> insert into computevalues(1,'compute1');

MariaDB [nova]> select * from compute;

+------+----------+

| id| name |

+------+----------+

|1 | compute1 |

+------+----------+

1 row in set (0.00 sec)

2.1.4 导出数据库

MysqLdump -uroot -p1 nova > nova.sql

# ls -l nova.sql

-rw-r--r-- 1 root root 1857 May 30 14:58nova.sql

2.1.6 删除非galera版本数据库

[root@localhost ~]# rpm -aq |grep maria

mariadb-libs-5.5.44-2.el7.centos.x86_64

mariadb-server-5.5.44-2.el7.centos.x86_64

mariadb-5.5.44-2.el7.centos.x86_64

# rpm -e --nodeps mariadb-libsmariadb-server mariadb

[root@localhost ~]# cd /usr

[root@localhost usr]# find ./ -name MysqL

[root@localhost usr]# cd /var/

[root@localhost var]# find ./ -name MysqL

./lib/MysqL

[root@localhost var]# rm lib/MysqL/ -rf

2.1.7 安装galera版本数据库

#yum install mariadb-galera-server galera

[root@localhost var]# rpm -aq |grep maria

mariadb-galera-common-5.5.40-3.el7.x86_64

mariadb-libs-5.5.44-2.el7.centos.x86_64

mariadb-5.5.44-2.el7.centos.x86_64

mariadb-galera-server-5.5.40-3.el7.x86_64

[root@localhost var]# rpm -aq |grep galera

mariadb-galera-common-5.5.40-3.el7.x86_64

galera-25.3.5-7.el7.x86_64

mariadb-galera-server-5.5.40-3.el7.x86_64

# systemctlenable mariadb.service

# systemctl startmariadb.service

设置密码:

#MysqL_secure_installation

Root密码为1,其他全部选择Y

2.1.8 导入数据

导入nova.sql

首先要创建nova数据库:

CREATE DATABASE nova;

GRANT ALL PRIVILEGES ON nova.* TO'nova'@'localhost' IDENTIFIED BY '1';

GRANT ALL PRIVILEGES ON nova.* TO'nova'@'%' IDENTIFIED BY '1';

FLUSH PRIVILEGES;

然后导入数据库nova:

MysqL -uroot -p1 nova < /root/nova.sql

查看:

MariaDB [(none)]> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| nova |

| performance_schema |

+--------------------+

4 rows in set (0.01 sec)

MariaDB [(none)]> use nova;

Reading table information for completion oftable and column names

You can turn off this feature to get aquicker startup with -A

Database changed

MariaDB [nova]> show tables;

+----------------+

| Tables_in_nova |

+----------------+

| compute |

+----------------+

1 row in set (0.00 sec)

MariaDB [nova]> select * from compute;

+------+----------+

| id| name |

+------+----------+

|1 | compute1 |

+------+----------+

1 row in set (0.00 sec)

OK,一切数据正常。

相关

总结

如果觉得编程之家网站内容还不错,欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。

如您喜欢交流学习经验,点击链接加入交流1群:1065694478(已满)交流2群:163560250

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值