Navicat: mysql backup error 1548cannotloadmysql. proc_MySQL

Navicat: mysql backup error 1548cannotloadmysql. proc Navicat

When backing up a database today, the title is incorrect and data cannot be backed up. So google will show it. (My database management tool is Navicat Premium)

Solution found: execute the following command

# Mysql_upgrade-u root-p

# Enter password: (Enter the password)

After you enter the password, the following message is displayed:

[root@AY130701184903434d7bZ usr]# mysql_upgrade -u root -pEnter password:Looking for 'mysql' as: mysqlLooking for 'mysqlcheck' as: mysqlcheckRunning 'mysqlcheck with default connection argumentsRunning 'mysqlcheck with default connection argumentsb3log.b3_solo_archiveDate                          OKb3log.b3_solo_archiveDate_article                  OKb3log.b3_solo_archiveDate_copy                     OKb3log.b3_solo_article                              OKb3log.b3_solo_comment                              OKb3log.b3_solo_link                                 OKb3log.b3_solo_option                               OKb3log.b3_solo_page                                 OKb3log.b3_solo_plugin                               OKb3log.b3_solo_preference                           OKb3log.b3_solo_statistic                            OKb3log.b3_solo_tag                                  OKb3log.b3_solo_tag_article                          OKb3log.b3_solo_user                                 OKmysql.columns_priv                                 OKmysql.db                                           OKmysql.event                                        OKmysql.func                                         OKmysql.general_log                                  OKmysql.help_category                                OKmysql.help_keyword                                 OKmysql.help_relation                                OKmysql.help_topic                                   OKmysql.host                                         OKmysql.ndb_binlog_index                             OKmysql.plugin                                       OKmysql.proc                                         OKmysql.procs_priv                                   OKmysql.servers                                      OKmysql.slow_log                                     OKmysql.tables_priv                                  OKmysql.time_zone                                    OKmysql.time_zone_leap_second                        OKmysql.time_zone_name                               OKmysql.time_zone_transition                         OKmysql.time_zone_transition_type                    OKmysql.user                                         OKRunning 'mysql_fix_privilege_tables'...OK

This command will generate a text file mysql_upgrade_info in the data directory, which contains the upgraded database version.

Run the command again to back up the database. you can back up the database by dumping the SQL file.