MySQL Bugs: #12577: Scheduled Backup-job stops at deleted tables

Bug #12577	Scheduled Backup-job stops at deleted tables
Submitted:	15 Aug 2005 7:34	Modified:	19 Aug 2005 11:19
Reporter:	Oliver Merk	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.0.20	OS:	Windows (Windows 2003 SBS)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
I have problems with a scheduled backup job, when a selected table from a schemata has been deleted from the database. Then the SQL-Backupfile conatins only structure and data from the tables "above" the deleted table. The Backup-job stops at the deleted table with an entry in the event viewer:

"The MySQL Server returned this Error:
MySQL Error Nr.1146-Table 'pecon.TableXYZ' doesn't exist"

All tables "after" the deleted table are not in the Backup-File! 

How to repeat:
1) Create a database with several tables and fill in some data. 
2) Create a Backup-project and include the whole database.
3) Run Backup and check SQL-Backupfile.
4) Delete a table in the database.
5) Run Backup again and compare SQL-Backupfile with previous backup.
6) If you delete the first table then NO DATA is in the SQl-Backup file.

Suggested fix:
The tables for a Backup project are stored in in a file named after the job "xxx.mbp" in XML-Format. Delete the missing table of the database from the mbp-file with a text-editor. It is surrounded by <table> ... </table> Tags.

Unfortunately MySQLAdministrator does not show tables in the Backup-Content area of the GUI that are present in the mbp-file, but have been already deleted from the database. Since these tables stop the backup job it would be very important to give the user this information.

Hi!

Thanks for your bug report.  I was able to reproduce this problem using WinXP and MA 1.1.1.

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