• tnurnberg@mysql.com's avatar
    Bug#17371: Unable to dump a schema with invalid views · c7ae355d
    tnurnberg@mysql.com authored
    'show create' works even on views that are short of a base-table (this
    throw a warning though, like you would expect). Unfortunately, this is
    not what mysqldump uses; it creates stand-in tables and hence requests
    'show fields' on the view which fails with missing base-tables.  The
    --force option prevents the dump from stopping at this point; furthermore
    this patch dumps a comment showing create for the offending view for
    better diagnostics. This solution was confirmed by submitter as solving
    their/clients' problem. Problem might become non-issue once mysqldump no
    longer creates stand-in tables.
    c7ae355d
mysqldump.result 119 KB