MySQL Bugs: #4525: Restore impossible

Bug #4525	Restore impossible
Submitted:	12 Jul 2004 18:52	Modified:	14 Jul 2004 9:31
Reporter:	David Sancho	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.0.6 beta	OS:	Windows (WindowsXP)
Assigned to:		CPU Architecture:	Any

Description:
In none of the Administrator versions I have done a restore. I always get the following error: "Error while retrieving Backup content."

The backup file has 500Mb.

The database has InnoDb and MySql tables.

Greetings

How to repeat:
Do a backup of a big database and try to restore.

Forget it.

I have discovered that the problem is mine (File Charset).

I do the backup on a remote server with Administrator, then compress using rar, download the file and decompress in my machine. Utf8 is lost during the process.

I am changing the status for not a bug according your own words:

"I have discovered that the problem is mine (File Charset)."

Thanks.

I have the same problem. The Backup File was created with MySQL Administrator 1.0.6, the restore never worked. Installed the MySQL Administrator 1.0.9, same behavior.

Also a restore problem using mysql administrator.
When I backup my schema, it creates a sql file but if I try to restore this file, it say : "The analyze operation was finished successfully" and stop the restore operation.
If I paste the sql file in Mysql Query Browser, in a script tab, the restore is impossible. I discovered that it came from the double quotes. The backup process create a query like this :
CREATE DATABASE "bibliography";
USE "bibliography";

If I try these queries in mysql query I got a syntax error.
If I remove the double quotes it works perfectly.
But I have no enough time to remove the quotes of all my create table queries in my backup file!

I hope my comments will help you to improve your software. 

Thanks.

NB: Another error I noticed : When I use the autodetect character set it detects UTF8, but my file is encoded latin1.

I am also having some trouble restoring my backup file using MySQL Administrator. I did a backup (UTF8) of my database (2GB) from one server and then tried to restore on another server but the restore interface just pops up a windows that says 'The Analyze operation was finished succesfully' but the Number of bytes processed is 0 and the progress bar is also at 0. I just copied the backup file over the LAN without zipping or tarring it. Anyone knows what give?