Resolved Error making backup and dump database

[Emanuel]

Server operating system version

os_CentOS 7

Plesk version and microupdate number

Plesk Obsidian v18.0.43_build1800220414.18

Hello,
When i try make a backup of the data bases, give this error,
Warning: Database "gestaoformacao"
Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 2: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'gestaoformacao'': Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted (1805)


when i try make a dump give this:
Unable to export a dump of gestaoformacao:

• mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'gestaoformacao'': Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted (1805)
• ("program 'mysqldump' finished with non-zero exit code: %d", 2)

i use Plesk Obsidian v18.0.43_build1800220414.18 os_CentOS 7.

Can some one help me?

 

[IgorG]

Some tables in the mysql database have an incorrect schema.
Upgrade the mysql database:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin -T --debug-check mysql

 

[Emanuel]

Hello IgorG

Using this command is there any possibility of the database crashing? because the last backup I have is more than 10 days old and I can't lose the information from those days.

 

[Emanuel]

Thanks IgorG Problem Solve

 

[pramodB]

Thanks IgorG Problem Solve

hi, nice to hear that you have sorted the issue, But can you please tell me how? so other also know that solution, I am facing the same issue now

 

[pramodB]

hi, nice to hear that you have sorted the issue, But can you please tell me how? so other also know that solution, I am facing the same issue now

thanks in advance