M
M
Mikhail Gilmutdinov2016-02-25 14:22:44
MySQL
Mikhail Gilmutdinov, 2016-02-25 14:22:44

How to fix an error when backing up databases?

Warning: mysql "______________"
Not all the data was backed up into /backup_pkz3/clients/___________/domains/_____________/databases/______________ successfully. mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = '____________________'': Cannot load from mysql.proc. The table is probably corrupted (1548)

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Anton B, 2016-02-25
@bigton

Options:
Maybe there is not enough space for the backup?
Maybe first optimize the tables (mysqloptimize)?

C
Cool Admin, 2016-02-25
@ifaustrue

They say you are not the first
. The command is run as follows.
$ mysql_upgrade
If you're getting an access denied error, pass along the username + password.
$ mysql_upgrade
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
FATAL ERROR: Upgrade failed
$ mysql_upgrade -u root -p

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question