Bug #24681 mysqldump treats views as tables
Submitted: 29 Nov 2006 9:13 Modified: 29 Dec 2006 9:29
Reporter: Kai Sautter (Basic Quality Contributor) Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:5.0.22 OS:
Assigned to: CPU Architecture:Any

[29 Nov 2006 9:13] Kai Sautter
MySQLdump adds drop table statements for views to the dumpfile. Furthermore, it adds unneccessary CREATE DATABASE and USE statements between the create table and create view statements.

How to repeat:
e.g. run

mysqldump --add-drop-table --allow-keywords -i -c -h<somehost> -d --quote-names
-r<somefile>.sql -u<user> -p --databases <database>

against a database containing views
[29 Nov 2006 9:29] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.27, and inform about the results.
[30 Dec 2006 0: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".