MySQL Bugs: #24391: MySQL Administrator Backup Failure

Bug #24391	MySQL Administrator Backup Failure
Submitted:	17 Nov 2006 12:16	Modified:	25 Dec 2006 9:24
Reporter:	Mathew Marchant	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.2.5 rc	OS:	Windows (Windows XP Pro SP2)
Assigned to:		CPU Architecture:	Any
Tags:	administrator, Backup, error, Failure, MySQL, SQL

Description:
Affected Software:
MySQL Server Version: MySQL 5.0.26 to 27 (community and standard editions)
MySQL Client Version: 5.1.11
MySQL Administrator Version: 1.2.5 rc
--------------------------------------

When attempting to run a database backup through MySQL administrator 1.2.5 rc, on either a remote or local host, the backup fails with the following error message:

Backup Error
An Error occured while executing the backup.

Error while analyzing an SQL statement.

SQL Log:
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.26-standard

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

Second SQL Log:
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.27-community-nt

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

--------------------------------------------

This happens on every backup attempt, changing backup options has not corrected the issue.

How to repeat:
Create any backup project, select any database and any table, with any backup options and attempt to execute the backup.

Suggested fix:
Downgrading to a previous version of MySQL Administrator corrects this problem

Thank you for a problem report. Please, send a dump of a database that demonstrates the behaviour described. I was not able to repeat it with my databases on 1.2.5 connected to local MySQL server v. 5.0.27.

2 database dumps sent to ftp, file name bug-data-24391.zip

I have another 3 database dumps using MySQL Administrator 1.2.3 rc which all fail to backup in 1.2.5 rc if you need them I can also upload those.

I am experiencing the same problem - after updating MySQL Admin to version 1.2.5rc I cannot make a backup of any database on a MySQL version 4.n server (fails on several different MySQL servers).

Please, try to repeat with a newer version, 1.2.6 rc (from GUI Tools 5.0r6), and inform about the results.

Even with the newer version I'm still experiencing the same problem - after updating MySQL Admin to version 1.2.6rc I cannot make a backup of any database on a MySQL version 4.n server (fails on several different MySQL servers).

I have the same problem.

it works fine with my local database, but crash when trying to backup a data base from my hosting provider

I thought that was a Mysql4 probleme, but, after switching to Mysql5, same problem. Downgrading mysql administrator worked fine.

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".

Very helpful !!! I do not have access to the dump from the original bug reporter. However it seems that several people seeing the same problem. Sure you could not rebuild the error if you are using different environment.

I'm affected by this bug. 
For what I've understood it is still not solved, so the only workaround is to downgrade to previous version of MySQL Administrator.

Can anyone tell me where to download MySQL Administrator for version 4.1?  (I'm getting crazy, I can't find it on the site!!)

Thank you,
Jesús.