{"id":274,"date":"2012-12-25T22:02:59","date_gmt":"2012-12-25T22:02:59","guid":{"rendered":"https:\/\/shan.info\/new\/mysqldump-couldnt-execute-show-function-status-where-db-your-db-here-column-count-of-mysql-proc-is-wrong-expected-20-found-16-created-with-mysql-50077-now-running-5\/"},"modified":"2012-12-25T22:02:59","modified_gmt":"2012-12-25T22:02:59","slug":"mysqldump-couldnt-execute-show-function-status-where-db-your-db-here-column-count-of-mysql-proc-is-wrong-expected-20-found-16-created-with-mysql-50077-now-running-5","status":"publish","type":"post","link":"https:\/\/shan.info\/new\/mysqldump-couldnt-execute-show-function-status-where-db-your-db-here-column-count-of-mysql-proc-is-wrong-expected-20-found-16-created-with-mysql-50077-now-running-5\/","title":{"rendered":"mysqldump: Couldn\u2019t execute \u2018SHOW FUNCTION STATUS WHERE Db = \u2018your-db-here\u201d: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50077, now running 50152. Please use mysql_upgrade to fix this error. (1558)"},"content":{"rendered":"<p><span style=\"font-family: 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.78333282470703px; text-align: justify; background-color: #d5d6d7;\">mysqldump: Couldn\u2019t execute \u2018SHOW FUNCTION STATUS WHERE Db = \u2018your-db-here\u201d: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50077, now running 50152. Please use mysql_upgrade to fix this error. (1558)<\/span><\/p>\n<p><span style=\"font-family: 'Lucida Grande', Verdana, Arial, sans-serif; font-size: 13px; line-height: 16.78333282470703px; text-align: justify; background-color: #d5d6d7;\">\u00a0<\/span><\/p>\n<p><span style=\"text-align: justify; background-color: #d5d6d7; line-height: 16.766666412353516px;\"><span style=\"font-family: 'Lucida Grande', Verdana, Arial, sans-serif; font-size: small;\">\/usr\/bin\/mysql_upgrade -uxxxx -pxxxxxx<\/span><\/span><\/p>\n<p><span style=\"text-align: justify; background-color: #d5d6d7; line-height: 16.766666412353516px;\"><span style=\"font-family: 'Lucida Grande', Verdana, Arial, sans-serif; font-size: small;\">\u00a0<\/span><\/span><\/p>\n<p style=\"margin: 0px 0px 1.5em; padding: 0px; border: 0px; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; vertical-align: baseline; color: #555555; line-height: 18px; background-color: #f5f5f5;\">\u5982\u679c\u4f60\u7684webmin\/virtualmin\u81ea\u52a8\u5907\u4efd\u51fa\u73b0\u4e0b\u9762\u7684\u9519\u8bef\uff0c\u90a3\u4e48\uff0c\u5c31\u662fmysql\u5347\u7ea7\u540e\u6ca1\u6709\u505a<span style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-family: inherit; vertical-align: baseline; color: #ff0000;\">mysql_upgrade\u00a0<\/span>\u8868\u4fee\u590d\u3002 \u5728\u65b0\u7248\u4e0b\u6267\u884cmysql_upgrade\u547d\u4ee4\uff0c\u5176\u5b9e\u8fd9\u4e2a\u547d\u4ee4\u5305\u542b\u4e00\u4e0b\u4e09\u4e2a\u547d\u4ee4\uff1a<\/p>\n<p style=\"margin: 0px 0px 1.5em; padding: 0px; border: 0px; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; vertical-align: baseline; color: #555555; line-height: 18px; background-color: #f5f5f5;\"># mysqlcheck \u2013check-upgrade \u2013all-databases \u2013auto-repai<\/p>\n<p style=\"margin: 0px 0px 1.5em; padding: 0px; border: 0px; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; vertical-align: baseline; color: #555555; line-height: 18px; background-color: #f5f5f5;\"># mysql_fix_privilege_tables<\/p>\n<p style=\"margin: 0px 0px 1.5em; padding: 0px; border: 0px; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; vertical-align: baseline; color: #555555; line-height: 18px; background-color: #f5f5f5;\"># mysqlcheck \u2013all-databases \u2013check-upgrade \u2013fix-db-names \u2013fix-table-names<\/p>\n<p style=\"margin: 0px 0px 1.5em; padding: 0px; border: 0px; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; vertical-align: baseline; color: #555555; line-height: 18px; background-color: #f5f5f5;\">Note: \u5728\u6bcf\u4e00\u6b21\u7684\u5347\u7ea7\u8fc7\u7a0b\u4e2d\uff0cmysql_upgrade\u8fd9\u4e2a\u547d\u4ee4\u6211\u4eec\u90fd\u5e94\u8be5\u53bb\u6267\u884c\uff0c\u5b83\u901a\u8fc7mysqlcheck\u547d\u4ee4\u5e2e\u6211\u4eec\u53bb\u68c0\u67e5\u8868\u662f\u5426\u517c\u5bb9\u65b0\u7248\u672c\u7684\u6570\u636e\u5e93\u540c\u65f6\u4f5c\u51fa\u4fee\u590d\uff0c\u8fd8\u6709\u4e2a\u5f88\u91cd\u8981\u7684\u4f5c\u7528\u5c31\u662f\u4f7f\u7528mysql_fix_privilege_tables\u547d\u4ee4\u53bb\u5347\u7ea7\u6743\u9650\u8868\u3002<\/p>\n<p><span style=\"text-align: justify; background-color: #d5d6d7; line-height: 16.766666412353516px;\"><span style=\"font-family: 'Lucida Grande', Verdana, Arial, sans-serif; font-size: small;\">\u00a0<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysqldump: Couldn\u2019t execute \u2018SHOW FUNCTION STATUS WHERE Db = \u2018your-db-here\u201d: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50077, now running 50152. Please use mysql_upgrade to fix this error. (1558) \u00a0 \/usr\/bin\/mysql_upgrade -uxxxx -pxxxxxx \u00a0 \u5982\u679c\u4f60\u7684webmin\/virtualmin\u81ea\u52a8\u5907\u4efd\u51fa\u73b0\u4e0b\u9762\u7684\u9519\u8bef\uff0c\u90a3\u4e48\uff0c\u5c31\u662fmysql\u5347\u7ea7\u540e\u6ca1\u6709\u505amysql_upgrade\u00a0\u8868\u4fee\u590d\u3002 \u5728\u65b0\u7248\u4e0b\u6267\u884cmysql_upgrade\u547d\u4ee4\uff0c\u5176\u5b9e\u8fd9\u4e2a\u547d\u4ee4\u5305\u542b\u4e00\u4e0b\u4e09\u4e2a\u547d\u4ee4\uff1a # mysqlcheck \u2013check-upgrade \u2013all-databases \u2013auto-repai # mysql_fix_privilege_tables # mysqlcheck \u2013all-databases \u2013check-upgrade \u2013fix-db-names \u2013fix-table-names [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"class_list":["post-274","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts\/274","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/comments?post=274"}],"version-history":[{"count":0,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts\/274\/revisions"}],"wp:attachment":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/media?parent=274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/categories?post=274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/tags?post=274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}