Bug #61924 Restore won´t work

• Submitted: 20 Jul 2011 6:52
• Modified: 5 Dec 2011 7:46
• Reporter: Alternativ End
• Status: Can't repeat
• Category: MySQL Workbench: Administration
• Severity: S1 (Critical)
• Version: 5.2.34
• OS: Windows (Server 2008 x64)
• CPU Architecture: Any

[20 Jul 2011 6:52] Alternativ End

Description:
Restoring databases from Workbench don´t work. Even after giving Workbench the right path to msyql.exe and mysqldump.exe. When you try to import from a file it hangs and you have to cancel it manually. If you do so you´ll get an error like: 

Operation failed with exitcode 1

08:27:20 Aborted by User

Restored database(s) maybe in an inconsistent state

Excecuting this or a similiar command with the Powershell gives me out an error that the operand "<" is not yet supported. The only way to get it work is via the good old cmd shell. I hope that you can file this issue.

How to repeat:
Just try to restore a file on Windows Server 2008 via Workbench.

Suggested fix:
I think it could have something todo with the Powershell and "<".

[20 Jul 2011 9:32] Peter Laursen

I have tried (briefly) to run various mysql command lien client from Powershell. never had any success.

Probably you will get this classifed as 'not supported'. But MySQL/Oracle should take Powershell seriously.

[20 Jul 2011 10:23] Alternativ End

Yes right, even because of you get very scary error message about inconsistent database. Do you think the restore problem is about the Powershell?

[20 Jul 2011 16:12] MySQL Verification Team

The file to be imported was created with which tool?. Are you able to provide it?. Thanks in advance.

[21 Jul 2011 6:46] Alternativ End

Sure, I have made it with this command and also out of the Workbench GUI itself.

mysqldump.exe --opt  -h 127.0.0.1 -uroot -pmypassword -rc:\BACKUP\mysql\%date%_sv.sql sv

[24 Aug 2011 17:49] Armando Lopez Valencia

Hello.
Thanks a lot for your report.
Can you please provide the following:
- The Dump files that you are trying to restore.
- The output of: Help -> System Info

[26 Aug 2011 7:48] Alternativ End

Hi,
with dump file you mean the SQL database? Im sorry but thats not possible because its a database with real data in it.  Meanwhile I have solved the problem by restoring the same database on the CLI with Windows cmd.

WMIShell: Set filters for local windows cli
MySQL Workbench CE for Windows version 5.2.34

Configuration Directory: C:\Users\Administrator.MYDOMAIN\AppData\Roaming\MySQL\Workbench

Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is not available on this system, so GDI is used for rendering.

OS: Microsoft Windows Server 2008 R2 Standard Edition Service Pack 1 (build 7601), 64-bit

CPU: 8x Intel(R) Xeon(R) CPU           E5620  @ 2.40GHz, 8.0 GiB RAM

Current user language: Deutsch (Deutschland)

[28 Sep 2011 22:44] MySQL Verification Team

Please try latest 5.2.35 if still is possible to make similar test. Thanks in advance.

[5 Oct 2011 7:01] Alternativ End

It seems to work with the new version now. At least the backup works fine now. I have no chance to test the restore right now.

Thanks!

[5 Oct 2011 9:58] Valeriy Kravchuk

Please, inform us if restore also works, when you'll get a chance to test it in your environment.

[6 Nov 2011 0:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[5 Dec 2011 7:17] Alternativ End

Im sorry but somehow I forgot about this thing. 
The restore does work again. So you can close this.

Thanks!

[5 Dec 2011 7:46] Valeriy Kravchuk

Not repeatable with recent versions.