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:
None 
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
Description:
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".