Bug #21329 restoring abnormally slowly
Submitted: 28 Jul 2006 14:16 Modified: 28 Jul 2006 18:11
Reporter: Mickael Besson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.1.9 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any
Tags: slow restore MySQL Administrator

[28 Jul 2006 14:16] Mickael Besson 
Description:
MySQL Administrator takes to much time to restore a backup, comparing to the method 'in command line'

How to repeat:
create a quite large backup with mysqldump

restore this backup with these two strategies :
- with mysql < backup.sql
- with MySQL Adm.

Compare durations

Suggested fix:
import system in MySQL Administrator
[28 Jul 2006 14:24] Valeriy Kravchuk 
Thank you for a problem report. Please, try to repeat with MySQL Administrator 1.2 (available at http://dev.mysql.com/downloads/gui-tools/5.0.html) and inform about the results.
[28 Jul 2006 14:47] Mickael Besson 
Indeed, this new beta version is more efficient.
Nevertheless, there is still the problem of UTF8 charset... (restore from mysqldump backup)

I hope that you correct this little bug quicky because our restore procedure is based on MySQL Administrator ... 

Thank you
[28 Jul 2006 15:42] MySQL Verification Team 
Thank you for the feedback. The utf8 issue is already reported for you
and in verified status, so this bug report can be closed as fixed in
release?

Thank you in advance.
[28 Jul 2006 15:58] Mickael Besson 
Yes. It can be closed now.
Thank you
[28 Jul 2006 18:11] MySQL Verification Team 
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/