Bug #22649 Compatibility mode apparently ignored on MySQL Admin 1.2.3.rc
Submitted: 25 Sep 2006 0:47 Modified: 24 Mar 2009 15:13
Reporter: Peter Richards Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Administrator Severity:S4 (Feature request)
Version:1.2.3.rc OS:Windows (XP)
Assigned to: CPU Architecture:Any

[25 Sep 2006 0:47] Peter Richards
Description:
Just upgraded to 1.2.3.rc to try to fix a problem where a backup on XP will not restore on UNIX. Unfortunately it did not fix the problem, but unchecking the COMMENTS option seems to have allowed the RESTORE to procede. Now my Create Table statements have additional clauses in them that fail on the target system even though I have Compatibility Mode checked in the BACKUP.
Prior to the upgrade my SQL looked like this
DROP TABLE IF EXISTS `AnimalCarerHistory`;
CREATE TABLE `AnimalCarerHistory` (
  `Animal_Number` int(10) unsigned NOT NULL default '0',
  `Carer` varchar(45) NOT NULL default ' ',
  `Record_Date` timestamp NOT NULL,
  `Carer_To` varchar(45) NOT NULL default ' ',
  `Notes` varchar(255) NOT NULL default ' ',
  PRIMARY KEY  (`Animal_Number`,`Carer`,`Record_Date`)
) TYPE=InnoDB;
After the upgrade it looks like this
DROP TABLE IF EXISTS `animalcarerhistory`;
CREATE TABLE `animalcarerhistory` (
  `Animal_Number` int(10) unsigned NOT NULL default '0',
  `Carer` varchar(45) NOT NULL default ' ',
  `Record_Date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Carer_To` varchar(45) NOT NULL default ' ',
  `Notes` varchar(255) NOT NULL default ' ',
  PRIMARY KEY  (`Animal_Number`,`Carer`,`Record_Date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
The restore fails with invalid SQL on the "default CURRENT_TIMESTAMP" statement.
When I edit this to replace it with the old statement I go back to the analyse failing with invalid character set!

How to repeat:
Perform a backup with Compatibility Mode checked.
[4 Oct 2006 7:19] Sveta Smirnova
Thank you for the report.

But as you can read in the MySQL Administrator manual: "Compatibility mode creates backup files that are compatible with older versions of MySQL Administrator.". It means "Compatibility mode" is not the same option as in mysqldump.

I only can to reclassify your report to "Feature request" for option allows to create compatible with older mysql versions dump.
[24 Mar 2009 15:13] Susanne Ebrecht
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. We won't add this feature request anymore.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/