#4264 Mysql Backup Database - Improperly backs up views

0.82
open
nobody
5
2013-07-03
2013-07-03
Chengui
No

Module/Command Location

Webmin -> Servers -> MySQL Database Server -> Backup Databases

Issue/Description

When making backups using the MySQL Database Server Module the backups are incomplete.
If the database contains views, instead of including the appropriate CREATE VIEW syntax of the view, it creates a table that is representative of the View. (Without including data (data in a view is linked, so this shouldn't matter)

Example

Backup should have produced something like:

CREATE VIEW v AS SELECT qty, price, qty*price AS value FROM t;

Instead outputs

CREATE TABLE v (qty, price, value);


Example is a representation of the error description not from actual attempt.


Settings Used

Option Value
Backup Destination: Local Directory
Only backup rows matching where clause: All rows
Add drop table statements to backup?: No
Character set for backup: Default
Backup compatability format: Default
Structure information to exclude: [None Selected from Checkbox]
Compression format: None
Backup within a transaction?: NO
Dump rows one at a time?: NO
When to run commands: Before/after each database
Scheduled backup enabled?: No
Backup Now

Discussion

  • Chengui

    Chengui - 2013-07-03

    Sorry I meant to put this in 1.630 please update

     
  • Jamie Cameron

    Jamie Cameron - 2013-07-03

    Webmin doesn't choose what gets included in a MySQL backup though - rather, it just runs the mysqldump command and saves the SQL that it outputs. You should try running the mysqldump command manually and see if the same thing happens.

     

Log in to post a comment.