Bug #44848 mysqldump produces stdout even if it encouters errors
| Submitted: | 13 May 2009 15:51 | Modified: | 12 Mar 2010 4:38 |
|---|---|---|---|
| Reporter: | Jozef Slezacek | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: mysqldump Command-line Client | Severity: | S1 (Critical) |
| Version: | 5.0.77, 5.1.45 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | Backup, mysqldump, stdout | ||
[13 May 2009 15:51]
Jozef Slezacek
[13 May 2009 16:45]
Valeriy Kravchuk
And what if the problematic table will be last of 1000 others that will be dumped successfully? Where mysqldump should put a dump of other 999 tables? You just should not overwrite existing dump until you are sure that the new one is successful. Actually, you'd better keep 2 last good copies at least. I think that change of behavior you ask about will help only in rare cases, when the very first (or only) table to dump is problematic.
[13 Jun 2009 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[12 Mar 2010 4:14]
MySQL Verification Team
Bug: http://bugs.mysql.com/bug.php?id=51975 was marked as duplicate of this one.
[12 Mar 2010 4:38]
Valeriy Kravchuk
It is easy to verify (see that duplicate). Just run mysqldump -user-dsdhshhs >/dev/null mysqldump -user-fnjfdnfd 2>/dev/null to make sure that usage messages (as well as --help option results) goes to stdout, NOT stderr as expected.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.066 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.