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

A gaskiya, idan kun yi amfaniphpMyAdmin, ba za ka iya samun kuskure a ina ne matsalar?

• Matsalar ita ce saboda kun haɓaka MariaDB koMySQL databasesigar.
• Haɓaka MariaDB koMySQLBayan sigar bayanai, ba a amfani da tsarin bayananmysql_upgradeumarnin don kammala haɓaka haɓakawa.
• Bayan haka, yayin aiki na bayanan MySQL, ana iya nuna saƙon kuskure.

WordPress pluginA lokacin tsarin ajiyar atomatik, kuskuren da ke biyo baya ya faru ▼

Gargaɗi: Kuskuren Database Ƙididdigar ginshiƙi na mysql.proc ba daidai ba ne. Ana tsammanin 21, an samo 20. An ƙirƙira tare da MariaDB 50560, yanzu yana gudana 100406. Da fatan za a yi amfani da mysql_upgrade don gyara wannan kuskuren Tambaya SHOW MATSAYI MATSAYI

• mysql.proc Wannan tebur tsarin ne a cikin 5.1 wanda ke yin rikodin bayanai game da hanyoyin da aka adana ko ayyuka.

Yadda za a gyara gargaɗin: Kuskuren Database Ƙididdigar ginshiƙi na mysql.proc ba daidai ba ne?

Mai zuwa kenanChen Weiliangwarware bayani.

shafi na 1:Amintaccen aiki shine a fara jujjuyawa ko sanyi madadin farko:

mysqldump -uroot -p123456 --quick --master-data=1 --all-databases --flush-logs --lock-tables >

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

shafi na 2:amfani da wadannanmysql_upgrade umarni don warwarewa

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

Mai zuwa shine tsarin aikin nunin SSH▼

[root@db lib]# mysql_upgrade -u root -p123456 -hdb --datadir=/var/lib/mysql/ --basedir=/
mysql_upgrade: the '--datadir' option is always ignored
mysql_upgrade: the '--basedir' option is always ignored
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--host=db'
Running 'mysqlcheck' with connection arguments: '--host=db'
mysql.columns_priv                                OK
mysql.db                                          OK
mysql.event                                       OK
mysql.func                                        OK
mysql.general_log
Error   : You can't use locks with log tables.
status  : OK
mysql.help_category                               OK
mysql.help_keyword                                OK
mysql.help_relation                               OK
mysql.help_topic                                  OK
mysql.host                                        OK
mysql.ndb_binlog_index                            OK
mysql.plugin                                      OK
mysql.proc                                        OK
mysql.procs_priv                                  OK
mysql.servers                                     OK
mysql.slow_log
Error   : You can't use locks with log tables.
status  : OK
mysql.student                                     OK
mysql.t1                                          OK
mysql.t2                                          OK
mysql.tables_priv                                 OK
mysql.time_zone                                   OK
mysql.time_zone_leap_second                       OK
mysql.time_zone_name                              OK
mysql.time_zone_transition                        OK
mysql.time_zone_transition_type                   OK
mysql.user                                        OK
................................................
test.newuser                                      OK
test.usertag                                      OK
Running 'mysql_fix_privilege_tables'...
WARNING: NULL values of the 'character_set_client' column ('mysql.proc' table) have been updated with a default value (latin1). Please verify if necessary.
WARNING: NULL values of the 'collation_connection' column ('mysql.proc' table) have been updated with a default value (latin1_swedish_ci). Please verify if necessary.
WARNING: NULL values of the 'db_collation' column ('mysql.proc' table) have been updated with default values. Please verify if necessary.
OK
[root@db lib]#

Akwai ƙarin mafita ga matsalolin bayanan MySQL a ƙasa▼

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

A cikin wannan koyawa za ta jagorance ku yadda ake haɓaka / shigar da MariaDB zuwa sabon sigar Mariadb7 akan Centos 10.10.2.Wannan koyawa kuma tana aiki tare da CWP da VestaCP ko kowane kwamitin kula da sabar VPS mai jituwa. MariaDB 10.10.2 yana da kwanciyar hankali yanzu…

Yadda ake gyara taken WordPress {{unknown}} matsalar oembed_cache?

Ta yaya batun farawa ke warware {{unknown}} oembed_cache?Akwai sabbin mutanen kafofin watsa labarai waɗanda kwanan nan suka koyi gina gidan yanar gizon WordPress kuma suna amfani da jigon farawa na robin.An samo {{unknown}}, kurakuran oembed_cache Lokacin da phpMyAdmin ya duba bayanan MySQL, an gano cewa...

An yiwa kuskuren tebur ɗin bayanan mysqld alama azaman faɗuwa kuma mafita ta ƙarshe (atomatik?) gyara

mysqld data table error is marked as rupted and last (atomatik?) Maganin gyara Wannan labarin zai gabatar muku da kuskuren lokacin da muka gyara tebur: Tebu \'./db_name/table_name\' an yiwa alama alama a matsayin fadowa kuma na ƙarshe...

Gargadi na MySQL: An samo layi inda auto_increment colum

Idan mai kula da gidan yanar gizon e-kasuwanci yana da isassun izini, za a iya kiyaye bayanan MySQL ta hanyar kwamitin kula da bayanai na phpMyAdmin.Ana iya yin "bincike" ko "tambayoyi" a kan ma'aunin bayanan WordPress lokacin da kurakurai suka faru a cikin bayanan.Amma watakila sai...