Xazulula isexwayiso: iphutha lesizindalwazi Isibalo sekholomu ye-mysql.proc akulungile.

Eqinisweni, uma usebenzisaphpMyAdmin, awukwazi ukuthola iphutha ikuphi inkinga?

• Inkinga ingoba uthuthukise i-MariaDB nomaMySQL databaseinguqulo.
• Thuthukisa i-MariaDB nomaMySQLNgemuva kwenguqulo yedathabheyisi, izakhiwo zedatha azisetshenziswamysql_upgradeumyalo wokuqedela isibuyekezo sokuthuthukisa.
• Ngemva kwalokho, ngesikhathi sokusebenza kwe-database ye-MySQL, imilayezo yamaphutha ingase ibonakale.

I-plugin ye-WordPressPhakathi nenqubo yokwenza isipele ngokuzenzakalelayo, kwenzeke iphutha elilandelayo ▼

Isexwayiso: Iphutha lesizindalwazi Inani lekholomu ye-mysql.proc alilungile. Kulindeleke 21, kutholwe 20. Idalwe no-MariaDB 50560, manje isebenzisa 100406. Sicela usebenzise i-mysql_upgrade ukulungisa leli phutha Umbuzo SHOW FUNCTION STATUS

• mysql.proc Leli yithebula lesistimu ku-5.1 elirekhoda ulwazi mayelana nezinqubo ezigciniwe noma imisebenzi.

Usilungisa kanjani isexwayiso: Iphutha lesizindalwazi Isibalo sekholomu ye-mysql.proc akulungile?

OkulandelayoU-Chen Weiliangisixazululo esibhaliwe.

Isinyathelo sesi-1:Ukwenza okuphephile ukulahla noma ukwenza isipele esibandayo kuqala:

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

• Sicela uguqule okungenhla kokuthi "123456" kube yi-password yakho ye-MySQL.

Isinyathelo sesi-2:sebenzisa okulandelayomysql_upgrade umyalo wokuxazulula

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

Okulandelayo inqubo yokubonisa ye-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]#

Kunezixazululo eziningi zezinkinga zesizindalwazi se-MySQL ngezansi▼

Ungabuyekeza/uthuthukele kanjani ku-MariaDB7 ku-VestaCP/CWP/CentOS 10.10.2?

Lesi sifundo sizokuqondisa ukuthi ungayithuthukisa kanjani/ufake i-MariaDB enguqulweni yakamuva ye-Mariadb 7 ku-Centos 10.10.2.Lesi sifundo sisebenza ne-CWP ne-VestaCP nanoma iyiphi enye iphaneli yokulawula iseva ye-VPS ehambisanayo. I-MariaDB 10.10.2 izinzile kakhulu manje...

Ilungiswa kanjani itimu ye-WordPress {{engaziwa}} inkinga ye-oembed_cache?

Isihloko sokuqala siyixazulula kanjani i-{{unknown}} embed_cache?Kukhona abantu abasha bemidiya abasanda kufunda ukwakha iwebhusayithi ye-WordPress futhi basebenzise itimu yokuqala ye-robin.Kutholwe {{okungaziwa}}, amaphutha e-oembed_cache Lapho i-phpMyAdmin ihlola isizindalwazi se-MySQL, kwatholakala ukuthi...

Iphutha lethebula ledatha le-mysqld limakwe njengeliphahlazekile futhi elokugcina (okuzenzakalelayo?) isisombululo sokulungisa

Iphutha lethebula ledatha ye-mysqld limakwe njengeliphahlazekile futhi elokugcina (okuzenzakalelayo?) isisombululo sokulungisa Lesi sihloko sizokwethula iphutha lapho silungisa ithebula: Ithebula \'./db_name/table_name\' imakwe njengeliphahlazekile futhi elokugcina...

Isexwayiso se-MySQL: Kutholwe umugqa lapho ikholamu ye-auto_increment

Uma umqondisi wewebhusayithi ye-e-commerce enezimvume ezanele, isizindalwazi se-MySQL singagcinwa ngephaneli yokulawula yedathabhesi ye-phpMyAdmin.Ukugcinwa kwetafula "ukuhlaziya" noma "ukuhlola" kungenziwa kusizindalwazi se-WordPress uma kwenzeka amaphutha kusizindalwazi.Kodwa mhlawumbe ke...