Yadda ake sabuntawa/ haɓakawa zuwa MariaDB7 don VestaCP/CWP/CentOS 10.10.2?

A cikin wannan koyawa za ta jagorance ku yadda akeCibiyoyin 7, haɓaka/saka MariaDB zuwa sabon sigar Mariadb10.10.2.

• Wannan koyawa kuma ta shafi CWP daVestaCPko kowane kwamitin kula da uwar garken VPS mai jituwa.

MariaDB 10.10.2 yanzu yana da ƙarfi sosai kuma an ƙara abubuwa da yawa kuma an inganta su a cikin wannan sakin.

• Za ki iyananDuba jerin duk canje-canje.

mun yi amfaniWordPress, Joomla, xenforo, Dandalin IPS da wasu abubuwan dogaro da suka dogara da suMySQL Rubutun PHP na DB yana bincika MariaDB 10.10.2, don haka yana da lafiya a haɓaka zuwa wannan sigar.

Menene MariaDB?

A takaice bayanin game da MariaDB:

• An tsara MariaDB donMySQLmadadin kai tsaye.
• Tare da ƙarin fasalulluka: sabon injin ajiya, ƙarancin kwari da ingantaccen aiki.
• MariaDB ta samo asali ne daga yawancin masu haɓakawa na asali na MySQL, waɗanda yanzu suke aiki don MariaDB Foundation da MariaDB Corporation, da kuma da yawa a cikin al'umma.

Don haɓakawa, bi waɗannan matakai masu sauƙi don haɓakawa zuwa sabon sigar.

Mataki 1: Share MariaDB tsohon sigar

• Share tsohuwar sigar MariaDB, kamar: 5.5 / 10.0 / 10.1 / 10.2 / 10.3

Kafin shigarwa, ana ba da shawarar cewa ku fara yin ajiyar wajeMySQL database.

Da farko, ajiye ajiyar my.cnf na yanzu▼

cp /etc/my.cnf /etc/my.cnf.bak

• Yanzu muna buƙatar cire sigar mariadb 7 na yanzu da aka shigar akan centos 5.5:

Don MariaDB 5.5 ▼

service mariadb stop / service mysql stop
rpm -e --nodeps galera
yum remove mariadb mariadb-server

• A wannan lokaci MariaDB 5.5 za a cire gaba daya, amma ba za a cire bayanan ba, kada ku damu.

Don sigogin da ke sama da MariaDB 10: 10.0 / 10.1 / 10.2 / 10.3 ▼

service mysql stop 
rpm -e --nodeps galera
yum remove MariaDB-server MariaDB-client

• A wannan gaba, MariaDB 10.0/10.1/10.2/10.3 za a share gaba ɗaya, amma ba za a share bayanan ba, kada ku damu.

Mataki 2: Sanya MariaDB 10.10.2

• Daga sigogin MariaDB 5.5/10.0/10.1/10.2/10.3, shigar/sabunta zuwa MariaDB 10.10.2.

Sanya Mariadb 10.10.2 repo na hukuma ▼

yum install nano epel-release -y

Yanzu gyara/ƙirƙiri fayil ɗin Repo/etc/yum.repos.d

Idan akwai sharewa ko adana fayilolin repo na yanzu, tabbatar cewa ba ku da wasu fayilolin ajiyar MariaDB ▼

mv /etc/yum.repos.d/mariadb.repo /etc/yum.repos.d/mariadb.repo.bak
nano /etc/yum.repos.d/mariadb.repo

Sai ki manna wadannan, sannan ki ajiye▼

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.10.2/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Bayan haka za mu shigar da Mariadb 10.10.2 ▼

yum clean all
yum install MariaDB-server MariaDB-client net-snmp perl-DBD-MySQL -y
yum update -y

Mai da fayil my.cnf ▼

rm -rf /etc/my.cnf
cp /etc/my.cnf.bak /etc/my.cnf

Sannan, kunna Mariadb don taya, kuma fara sabis ɗin:

systemctl enable mariadb
service mysql start

Mataki na 3: Haɓaka bayanan bayanai na yanzu

Bayan shigarwa, muna buƙatar haɓaka bayanai na yanzu ta hanyar umarni mai zuwa ▼

mysql_upgrade

• Idan babu wani abu, kun sami nasarar haɓaka MariaDB 5.5 / 10.0 / 10.1 / 10.2 / 10.3 zuwa sabon sigar MariaDB 10.10.2.

Idan kana buga umarnin mysql_upgrade Lokacin haɓaka bayanan bayanai, saƙon kuskuren yana bayyana ▼

[root@ ~]# mysql_upgrade
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
FATAL ERROR: Upgrade failed

Da fatan za a yi amfani da waɗannanmysql_upgrade umarnin a gyara ▼

mysql_upgrade -u root --datadir=/var/lib/mysql/ --basedir=/ --password=123456

• Da fatan za a canza abin da ke sama "123456" zuwa tushen kalmar sirri na MySQL ko Mariadb.

A ƙarshe, zaku iya tabbatar da sigar bayanan MySQL ko Mariadb ta hanyar gudanar da wannan umarni daga tashar SSH ▼

mysql -V

Kariya

Idan bayananku na MariaDB yana da saƙon kuskure iri ɗaya▼

警告：数据库错误 Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50560, now running 100406. Please use mysql_upgrade to fix this error 查询 SHOW FUNCTION STATUS

Don mafita ga kurakuran bayanai na MariaDB, da fatan za a danna hanyar haɗin da ke ƙasa don dubawa▼

Magance gargaɗin: Kuskuren bayanai Ƙididdigar ginshiƙi na mysql.proc ba daidai ba ne.

A zahiri, idan kuna amfani da phpMyAdmin, ba za ku iya samun kuskuren inda matsalar take ba?Matsalar ita ce saboda kun haɓaka sigar bayanan bayanai na MariaDB ko MySQL.Bayan haɓaka sigar bayanan MariaDB ko MySQL, tsarin bayanan ba a gama amfani da umarnin mysql_upgrade ba...