MySQL Forums
Forum List  »  Newbie

Re: mysqldump new problem
Posted by: Scott Jalbert
Date: November 29, 2021 02:07PM

Looks like reddit got the answer;
https://www.reddit.com/r/mysql/comments/r50yor/mysqldump_new_problem/

For some reason all databases fails the whole backup silently. This might be a bug in mysqldump? None of the guides I'm reading mention this not working. I have to specifically tell it what database I want now.

This works; mysqldump --no-tablespaces --single-transaction --quick -p -u zabbix zabbix > ~/backups/full-backup-$(date +%F).sql

Background info;

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| zabbix |
+--------------------+
2 rows in set (0.01 sec)


mysql> SHOW GRANTS;
+------------------------------------------------------------+
| Grants for zabbix@localhost |
+------------------------------------------------------------+
| GRANT USAGE ON *.* TO \zabbix`@`localhost` |`
| GRANT ALL PRIVILEGES ON \zabbix`.* TO `zabbix`@`localhost` |`
+------------------------------------------------------------+
2 rows in set (0.00 sec)

Options: ReplyQuote


Subject
Written By
Posted
November 29, 2021 09:37AM
November 29, 2021 10:00AM
November 29, 2021 10:10AM
November 29, 2021 10:24AM
November 29, 2021 10:32AM
November 29, 2021 10:41AM
November 29, 2021 12:29PM
November 29, 2021 12:45PM
November 29, 2021 01:24PM
Re: mysqldump new problem
November 29, 2021 02:07PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.