Bug #16509 restore doesn't restore files made by previous versions of Administrator

• Submitted: 14 Jan 2006 23:17
• Modified: 31 Jul 2006 18:09
• Reporter: Jim Michaels
• Status: Closed
• Category: MySQL Administrator
• Severity: S2 (Serious)
• Version: 1.0.17
• OS: Windows (XP Pro SP2 multiprocessor)
• CPU Architecture: Any
• Tags: Backup

[14 Jan 2006 23:17] Jim Michaels

Description:
errors instead of a restored database.

How to repeat:
I backed up my database with the version of administrator GUI made for MySQL 4.1 and unchecked the keys checkbox (why that's on by default I don't know).  the default charset is latin1.  
I uninstalled everything (mysql server, query browser, administrator) and installed the new 5.0.18 database, 1.1.7 administrator, 1.1.19 query browser) .
Tried to do a restore using new Administrator GUI's defaults except the charset, which had to be set for latin1.  got an error consistently about a connection.
brought up mysql cmd-line and executed the DDL script fine.
tried the administrator again and got "an internal error occurred".

Suggested fix:
use mysql command-line to execute SQL scripts to restore databases.

[14 Jan 2006 23:19] Jim Michaels

DDL script in question

Attachment: all 20060114_1408.sql (text/plain), 67.27 KiB.

[14 Jan 2006 23:54] Jim Michaels

I forgot to add that I turned on the checkbox to create databases if they don't exist.

[26 Jan 2006 22:16] Jorge del Conde

I was able to reproduce this bug using MA 1.1.7 and the attached SQL file

[31 Jul 2006 18:09] MySQL Verification Team

Thank you for the bug report. I was unable to repeat with MySQL Administrator 1.2.1 Beta.