MySQL Bugs: #10738: Automatic Backup fails when renaming Table

Bug #10738	Automatic Backup fails when renaming Table
Submitted:	19 May 2005 11:40	Modified:	28 May 2005 16:20
Reporter:	Fabian Hess	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.0.19	OS:	Windows (Win XP)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
When renaming a table, a Backup Project fails when trying to backup this table and aborts. In this case, "batches_new" was renamed to "batches"This is what the log says:

----
2005-05-17 22:05 - Backup started.
Preparing backup for for profile SQLBackup.
Connections loaded from file C:\Dokumente und Einstellungen\aheinema\Anwendungsdaten\MySQL\mysqlx_user_connections.xml.
Connection Makaintern selected.
Connection to server localhost:3306 established.
Profiled C:\Dokumente und Einstellungen\aheinema\Anwendungsdaten\MySQL\SQLBackup.mbp loaded.

Starting backup...

`access`                       (1/22)
`registerdb`                   (2/22)
`columns_priv`                 (3/22)
`db`                           (4/22)
`func`                         (5/22)
`host`                         (6/22)
`tables_priv`                  (7/22)
`user`                         (8/22)
`user_info`                    (9/22)
`batches_new`                  (10/22)
`batches_original`             (11/22)
`reports`                      (12/22)
`reports_test`                 (13/22)
`baugruppe`                    (14/22)
`bilder`                       (15/22)
`bilderzaehler`                (16/22)
`branche`                      (17/22)
`kunde`                        (18/22)
`maschinentyp`                 (19/22)
`werkstoff`                    (20/22)
`werkzeugmenu`                 (21/22)
`werkzeugzusatz`               (22/22)

2005-05-17 22:05 - Backup written successfully.
----------------------------------------
2005-05-18 22:05 - Backup started.
Preparing backup for for profile SQLBackup.
Connections loaded from file C:\Dokumente und Einstellungen\aheinema\Anwendungsdaten\MySQL\mysqlx_user_connections.xml.
Connection Makaintern selected.
Connection to server localhost:3306 established.
Profiled C:\Dokumente und Einstellungen\aheinema\Anwendungsdaten\MySQL\SQLBackup.mbp loaded.

Starting backup...

`access`                       (1/22)
`registerdb`                   (2/22)
`columns_priv`                 (3/22)
`db`                           (4/22)
`func`                         (5/22)
`host`                         (6/22)
`tables_priv`                  (7/22)
`user`                         (8/22)
`user_info`                    (9/22)

ERROR: 2005-05-18 22:05 - The following error occured: 
C:\Dokumente und Einstellungen\aheinema\Anwendungsdaten\MySQL\SQLBackup.mbp

How to repeat:
Rename a table of choice.

Suggested fix:
When choosing what databases to backup, Administrator should not care about the tables (esp. their names). It should just backup all tables, no matter what they're called.

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

Using the tables's names is the way for to control partial
databases backup.

Using the option [X] Complete backup on the Advanced Option page should not require any of the original tables but should backup all tables (like expressed in the description text). Please verify that this option works as expected or fix accordingly.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html