centos6Mysql如何导入数据库_mysql命令行导入sql数据库CentOS 6.5上安装MariaDB

CentOS 6.5上安装MariaDB作者：chszs，转载需注明。博客主页：http://blog.csdn.net/chszs

1、软件环境：CentOS 6.5 x64

MariaDB 5.5.36

2、安装过程1)在/etc/yum.repos.d/目录创建MariaDB.repo文件，内容如下：

# MariaDB 5.5 CentOS repository list - created 2014-03-04 11:20 UTC

#http://mariadb.org/mariadb/repositories/ [mariadb]

name = MariaDB

baseurl =http://yum.mariadb.org/5.5/centos6-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

2)在Shell环境下执行命令

# yum install MariaDB-server MariaDB-client

Loaded plugins: fastestmirror, security

base | 3.7 kB 00:00

base/primary_db | 4.4 MB 01:11

extras | 3.4 kB 00:00

extras/primary_db | 19 kB 00:00

mariadb | 1.9 kB 00:00

mariadb/primary_db | 15 kB 00:00

updates | 3.4 kB 00:00

updates/primary_db | 2.1 MB 00:22

Setting up Install Process

Resolving Dependencies

--> Running transaction check

---> Package MariaDB-client.x86_64 0:5.5.36-1.el6 will be obsoleting

--> Processing Dependency: MariaDB-common for package: MariaDB-client-5.5.36-1.el6.x86_64

---> Package MariaDB-server.x86_64 0:5.5.36-1.el6 will be obsoleting

---> Package mysql.x86_64 0:5.1.71-1.el6 will be obsoleted

---> Package mysql-server.x86_64 0:5.1.71-1.el6 will be obsoleted

--> Running transaction check

---> Package MariaDB-common.x86_64 0:5.5.36-1.el6 will be installed

--> Processing Dependency: MariaDB-compat for package: MariaDB-common-5.5.36-1.el6.x86_64

--> Running transaction check

---> Package MariaDB-compat.x86_64 0:5.5.36-1.el6 will be obsoleting

---> Package mysql-libs.x86_64 0:5.1.71-1.el6 will be obsoleted

--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================================================

Package Arch Version Repository Size

==================================================================================================================

Installing:

MariaDB-client x86_64 5.5.36-1.el6 mariadb 10 M

replacing mysql.x86_64 5.1.71-1.el6

MariaDB-compat x86_64 5.5.36-1.el6 mariadb 2.7 M

replacing mysql-libs.x86_64 5.1.71-1.el6

MariaDB-server x86_64 5.5.36-1.el6 mariadb 42 M

replacing mysql-server.x86_64 5.1.71-1.el6

Installing for dependencies:

MariaDB-common x86_64 5.5.36-1.el6 mariadb 23 k

Transaction Summary

==================================================================================================================

Install 4 Package(s)

Total download size: 55 M

Is this ok [y/N]: y

Downloading Packages:

(1/4): MariaDB-5.5.36-centos6-x86_64-client.rpm | 10 MB 04:45

(2/4): MariaDB-5.5.36-centos6-x86_64-common.rpm | 23 kB 00:00

(3/4): MariaDB-5.5.36-centos6-x86_64-compat.rpm | 2.7 MB 01:02

(4/4): MariaDB-5.5.36-centos6-x86_64-server.rpm | 42 MB 17:44

------------------------------------------------------------------------------------------------------------------

Total 40 kB/s | 55 MB 23:34

warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY

Retrieving key fromhttps://yum.mariadb.org/RPM-GPG-KEY-MariaDB Importing GPG key 0x1BB943DB:

Userid: "Daniel Bartholomew (Monty Program signing key) "

From :https://yum.mariadb.org/RPM-GPG-KEY-MariaDB Is this ok [y/N]: y

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

Installing : MariaDB-compat-5.5.36-1.el6.x86_64 1/7

Installing : MariaDB-common-5.5.36-1.el6.x86_64 2/7

Error in PREIN scriptlet in rpm package MariaDB-server-5.5.36-1.el6.x86_64

******************************************************************

A MySQL or MariaDB server package (mysql-server-5.1.71-1.el6.x86_64) is installed.

The current MariaDB server package is provided by a different

vendor (CentOS) than Monty Program AB. Some files may be installed

to different locations, including log files and the service

startup script in /etc/init.d/.

Upgrading directly from MySQL 5.1 to MariaDB 5.5 may not

be safe in all cases. A manual dump and restore using mysqldump is

recommended. It is important to review the MariaDB manual's Upgrading

section for version-specific incompatibilities.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf

files

- Shut down the MySQL server cleanly

- Remove the existing MySQL packages. Usually this command will

list the packages you should remove:

rpm -qa | grep -i '^mysql-'

You may choose to use 'rpm --nodeps -ev ' to remove

the package which contains the mysqlclient shared library. The

library will be reinstalled by the MariaDB-shared package.

- Install the new MariaDB packages supplied by Monty Program AB

- Ensure that the MariaDB server is started

- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process. Important details

can be found in the MariaDB manual, in the Upgrading section.

******************************************************************

error: %pre(MariaDB-server-5.5.36-1.el6.x86_64) scriptlet failed, exit status 1

error: install: %pre scriptlet failed (2), skipping MariaDB-server-5.5.36-1.el6

Installing : MariaDB-client-5.5.36-1.el6.x86_64 4/7

Erasing : mysql-5.1.71-1.el6.x86_64 5/7

Erasing : mysql-libs-5.1.71-1.el6.x86_64 6/7

Verifying : MariaDB-common-5.5.36-1.el6.x86_64 1/7

Verifying : MariaDB-compat-5.5.36-1.el6.x86_64 2/7

Verifying : MariaDB-client-5.5.36-1.el6.x86_64 3/7

Verifying : mysql-libs-5.1.71-1.el6.x86_64 4/7

Verifying : MariaDB-server-5.5.36-1.el6.x86_64 5/7

mysql-server-5.1.71-1.el6.x86_64 was supposed to be removed but is not!

Verifying : mysql-server-5.1.71-1.el6.x86_64 6/7

Verifying : mysql-5.1.71-1.el6.x86_64 7/7

Installed:

MariaDB-client.x86_64 0:5.5.36-1.el6 MariaDB-compat.x86_64 0:5.5.36-1.el6

Dependency Installed:

MariaDB-common.x86_64 0:5.5.36-1.el6

Replaced:

mysql.x86_64 0:5.1.71-1.el6 mysql-libs.x86_64 0:5.1.71-1.el6

Failed:

MariaDB-server.x86_64 0:5.5.36-1.el6 mysql-server.x86_64 0:5.1.71-1.el6

Complete!

更多:mysql命令行导入sql数据库CentOS 6.5上安装MariaDB

https://www.002pc.comhttps://www.002pc.com/mysql/3986.html

你可能感兴趣的6.5,MariaDB,CentOS,安装linux清空磁盘centos 6.5 minimal 安装及vm-tools安装

安装vm-->注册vm-->新建一个虚拟机(选择等会安装系统)-->加载iso-->配置桥接-->启动这里可能碰到一个cpu的虚拟化配置，需要在bios里的配置设置为enable

linux安装域名拦截CentOS6.5 gcc升级到4.8.2

操作系统：Centos 6.5 64位原GCC版本：4.4.7；目标：升级GCC到4.8.2，以支持C++11。

条形码 pythonCentOS 6.5下安装Python 3.5.2(与Python2并存)

本文主要给大家介绍了关于CentOS 6.5 安装Python 3.5.2并与Python2并存的相关内容，分享出来供大家参考学习，下面来看看详细的介绍：

安装步骤如下

1、准备编译环境(环境如果不对

linux网卡设置dhcp升级CentOS 6.5中VIM7.2到VIM7.4

升级CentOS 6.5中VIM7.2到VIM7.4查看是否安装：[root@localhost ~]# rpm -qa| grep vimvim-minimal-7.2.411-1.8.el6.x86

linux shell input[Linux]CentOS Minimal版安装纪录

CentOS Minimal版安装纪录 由于minimal版本的CentOS默认安装软件并不多，所以很多软件都需要自己后期手动进行安装。

linux的git安装配置centos 安装elastic-job

本文叙述的是如何在centos下安装当当的elastic-job中间件，elastic-job具体的作用可以去google或者谷歌看下。

linux磁盘收缩CentOS 6.0 安装 KDE 桌面系统

电脑技术002pc网对《linux磁盘收缩CentOS 6.0 安装 KDE 桌面系统》总结来说，为我们linux教程很实用。

linux java 抓包工具CentOS系统怎么安装GitLab客户端

在CentOS安装GitLab的方法非常的简单吧,但过滤感觉还是蛮多的,下面小编就来给各位朋友详细介绍一下CentOS系统安装GitLab客户端步骤。CentOS系统安装GitLab客户端步骤一

直连linux ping不通centos安装vbox addition

在centos下安装vbox addition需要下载当前内核的头文件yum install kernel-devel电脑技术002pc网对《直连linux ping不通centos安装vbox addition

linux磁盘空间限制Install Zabbix 2.2.1 on CentOS 6.5

Server and Client Platform: CentOS 6.5 x86_64Windows client platform: Windows server 2012Note: please

0踩

赏

0 赞