Bug #47706 | Views in a mysqldump can overwrite tables even with skip-add-drop-table | ||
---|---|---|---|
Submitted: | 29 Sep 2009 10:54 | Modified: | 29 Sep 2009 11:18 |
Reporter: | Hartmut Holzgraefe | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: mysqldump Command-line Client | Severity: | S3 (Non-critical) |
Version: | mysql-5.1.39, 5.0, 5.1 bzr | OS: | Linux |
Assigned to: | CPU Architecture: | Any |
[29 Sep 2009 10:54]
Hartmut Holzgraefe
[29 Sep 2009 11:18]
Sveta Smirnova
Thank you for the report. Verified as described.
[29 Sep 2009 11:37]
Peter Laursen
I'll repeat what I have written elsewhere, :-) The 'dummy tables' was a stupid idea from the beginning. A view_checks variable similar to foreign_key_checks is required to solve all the issues reported with failures when restoring VIEWs.