Bug #7895 Backup and restore compatibility

• Submitted: 14 Jan 2005 5:15
• Modified: 7 Feb 2005 16:27
• Reporter: Charles Yap II
• Status: Closed
• Category: MySQL Administrator
• Severity: S3 (Non-critical)
• Version: 1.0.19
• OS: Windows (Windows XP SP2)
• Assigned to: Mike Lischke
• CPU Architecture: Any

[14 Jan 2005 5:15] Charles Yap II

Description:
When you use mySQL Administrator to backup a database file on a mySQL server 4.1.8 a problem will occur if you try to restore the backup file into a mySQL server 4.0.22 the error would be on the lines  "DEFAULT CHARSET=latin1" you still have to remove it from the backup file inorder for you to restore it in ang older mySQL database server esp 4.0.22

How to repeat:
1.) Backup first using the backup tool of mySQL administrator from an database stored on a mySQL server 4.1.8
2.) Try Restoring the backup uped file also still using the mySQL administrator to an mysql server 4.0.22

Suggested fix:
Provide deletion of the line "DEFAULT CHARSET=latin1" in the mysql Administrator backup

[7 Feb 2005 16:27] Mike Lischke

Added a compatibility mode option for backup. It uses the sql_mode = MYSQL323 assignement for backup.