Gadzirisa yambiro: mhosho yedatabase Column count ye mysql.proc haina kururama.

Muchokwadi, kana ukashandisaphpMyAdmin, haugone kuwana kukanganisa dambudziko riripi?

• Dambudziko nderekuti wakakwidziridza MariaDB kanaMySQL databaseshanduro.
• Simudzira MariaDB kanaMySQLMushure meiyo database vhezheni, zvimiro zve data hazvishandiswemysql_upgraderaira kuti upedze kukwidziridza update.
• Mushure mezvo, panguva yekushanda kwe database yeMySQL, mameseji ekukanganisa anogona kuratidzwa.

WordPress pluginMunguva ye otomatiki backup maitiro, inotevera kukanganisa kwakaitika ▼

Yambiro: Database error Column count ye mysql.proc isiriyo. Zvinotarisirwa makumi maviri nerimwe, zvawanikwa 21. Yakagadzirwa ichishandisa MariaDB 20, parizvino inoshandisa 50560. Ndokumbira ushandise mysql_upgrade kugadzirisa dambudziko iri Query SHOW FUNCTION STATUS

• mysql.proc Iyi itafura yehurongwa mu 5.1 inonyora ruzivo pamusoro pemaitiro akachengetwa kana mabasa.

Nzira yekugadzirisa yambiro: Database error Column count ye mysql.proc haina kururama?

Izvi zvinoteveraChen Weiliangyakanyorwa mhinduro.

Chikamu 1 步:Tsika yakachengeteka ndeyekurasa kana kutonhora backup kutanga:

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

• Ndokumbirawo uchinje zviri pamusoro "123456" kune yako MySQL midzi password.

Chikamu 2 步:shandisa zvinoteveramysql_upgrade raira kugadzirisa

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

Izvi zvinotevera SSH kuratidzira mashandiro maitiro▼

[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]#

Kune mamwe mhinduro kuMySQL database matambudziko pazasi▼

Nzira yekuvandudza/kusimudzira kuMariaDB7 yeVestaCP/CWP/CentOS 10.10.2?

Muchidzidzo chino tichakutungamirira maitiro ekusimudzira/kuisa MariaDB kune yazvino Mariadb7 vhezheni paCentos 10.10.2.Ichi chidzidzo chinoshandawo neCWP uye VestaCP kana chero imwe inoenderana neVPS server control panel. MariaDB 10.10.2 yakanyatsogadzikana zvino...

Maitiro ekugadzirisa WordPress theme {{isingazivikanwe}} oembed_cache nyaya?

Nyaya yekutanga inogadzirisa sei {{zvisingazivikanwe}} oembed_cache?Kune midhiya mitsva vanhu vachangobva kudzidza kuvaka WordPress webhusaiti uye kushandisa robin kutanga theme.Yakawanikwa {{isingazivikanwe}}, oembed_cache zvikanganiso Apo phpMyAdmin yakaongorora dhatabhesi reMySQL, zvakaonekwa kuti...

mysqld data tafura kukanganisa kwakanyorwa sekuparara uye kwekupedzisira (otomatiki?) kugadzirisa mhinduro

Iyo mysqld data tafura kukanganisa kwakanyorwa sekudonha uye kwekupedzisira (otomatiki?) kugadzirisa mhinduro Chinyorwa ichi chinokuzivisa iwe kukanganisa patinogadzira tafura: Tafura \'./db_name/table_name\' yakanyorwa seyakapwanyika uye yekupedzisira...

MySQL Yambiro: Yakawanikwa mutsara uko auto_increment colum

Kana iyo e-commerce webhusaiti maneja ane mvumo yakakwana, iyo MySQL dhatabhesi inogona kuchengetedzwa kuburikidza nephpMyAdmin database control panel.Kugadzirisa tafura "kuongorora" kana "cheki" inogona kuitwa pane WordPress dhatabhesi kana zvikanganiso zvikaitika mudhatabhesi.Asi pamwe ipapo...