search

dsteinkopf / backup-all-mysql

Docker image to do automatic backups of a mysql DB.
https://nerdblog.steinkopf.net/2017/04/backup-all-mysql-docker-image-fuer-einfaches-backup/
GNU General Public License v2.0
14 stars 8 forks source link

mysqldump error #17

Open perler opened 5 years ago

perler commented 5 years ago

on strangle only some of my instances I get this error:

mysqldump: Couldn't execute 'SHOW FIELDS FROMhost_summary': View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to u se them (1356)

the mysql servers that are backed up are mysql 5.7 on ubuntu 18.04.

google says: https://www.osso.nl/blog/mysql-sys-schema-mysqldump-failure/

could you have a look?

dsteinkopf commented 5 years ago

Hmm. I am doing several mysql backups using this script (within the docker image https://hub.docker.com/repository/docker/dsteinkopf/backup-all-mysql). Some of them use mysql 5.7. I've never seen this error. How can I help you?

perler commented 5 years ago

not sure ;)

I will recreate one of the containers with the error message, let's see.

On Fri, 15 Nov 2019 at 11:10, dsteinkopf notifications@github.com wrote:

Hmm. I am doing several mysql backups using this script (within the docker image https://hub.docker.com/repository/docker/dsteinkopf/backup-all-mysql). Some of them use mysql 5.7. I've never seen this error. How can I help you?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/dsteinkopf/backup-all-mysql/issues/17?email_source=notifications&email_token=AAEYD5G7VLJ3535HY7UVY3LQTZYS7A5CNFSM4JNW7ZWKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEEE65HA#issuecomment-554299036, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEYD5HLIPG3PUALCVENLMLQTZYS7ANCNFSM4JNW7ZWA .

-- PGP: http://pgp.mit.edu/pks/lookup?op=get&search=0x379B9007F0B4F795 https://mail.google.com/mail/u/0/?view=cm&fs=1&tf=1&to=perler@gmail.com

thib3113 commented 2 years ago

I got the same error . And I fix it by running mysql_upgrade -u root -p on the server, to upgrade the mysql database . ( updating mysql doesn't always update the system database )