Bug #102501 | Backup file creation error | ||
---|---|---|---|
Submitted: | 6 Feb 2021 15:15 | Modified: | 11 Feb 2021 12:36 |
Reporter: | Leandro Damasio | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Workbench | Severity: | S2 (Serious) |
Version: | 8.0.23, 8.0.26, 8.0.27 | OS: | Windows (Microsoft Windows 10 Home Single Language) |
Assigned to: | CPU Architecture: | Any | |
Tags: | WBBugReporter |
[6 Feb 2021 15:15]
Leandro Damasio
[11 Feb 2021 12:36]
MySQL Verification Team
Hello Leandro Damasio, Thank you for the bug report. Verified as described. Regards, Ashwini Patil
[11 Feb 2021 12:38]
MySQL Verification Team
8.0.23 test results
Attachment: 102501_test_results.png (image/png, text), 22.74 KiB.
[16 Feb 2021 15:28]
Johann Lodina
The RESTORE of connections backup files doesn't work anymore too.
[16 Feb 2021 15:30]
Johann Lodina
Error-Message when trying to RESTORE a connections backup file
Attachment: MySQL-Workbench_Error-Restore-Connections.PNG (image/png, text), 16.68 KiB.
[6 May 2021 11:17]
Johann Lodina
The BUG is still there in Version 8.0.24 of MySQL Workbench.
[13 May 2021 21:23]
D K
The BUG is still there in Version 8.0.25 of MySQL Workbench. Both Backup and Restore connections functionality is not working on Windows Pro and Enterprise 64bit.
[14 Jun 2021 22:29]
Michael Jarn Gotostos
Backup and Restore connection feature still not working Workbench 8.0.25 Windows 10 Pro
[2 Aug 2021 13:47]
Nilanjan Saha
This is still broken in 8.0.26. Do you have ETA?
[16 Aug 2021 13:06]
Gerrit Haase
6 months, and still broken, really? Fix it, please!
[18 Aug 2021 9:18]
Kaito Mabashi
Please fix it as soon as possible. It's very inconvenient.
[18 Aug 2021 9:18]
Kaito Mabashi
Please fix it as soon as possible. It's very inconvenient.
[14 Sep 2021 0:17]
Jongha Ahn
8.0.26 still doesn't work.
[22 Sep 2021 7:19]
MySQL Verification Team
Bug #105003 marked as duplicate of this one
[28 Sep 2021 14:26]
Scott Figario
I've got over 50 connections I now need to recreate manually because this BASIC functionality is broken. Don't you guys do even minimal Q & A before doing a release? Never mind that its been over 8 months since this bug report was submitted... how is this issue not fixed yet???
[15 Oct 2021 4:30]
Avnish Awasthi
any update on this bugfix? export feature still not working. Using MySQL Workbench version 8.0.26
[21 Oct 2021 12:14]
Jason Alvarez
Hello, I just upgraded to 8.0.27 and this has worked for me for many years. Now I can't restore. Any workaround?
[22 Oct 2021 15:17]
Lisa Esselink
Restore work-around for this bug: - Unzip the backup file (two files are in there: connections.xml and server_instances.xml) - Copy these files (in windows) to: C:\Users\<user>\AppData\Roaming\MySQL\Workbench (replace <user> with your own windows username) Done! Backup work-around for this bug: - Zip the files connections.xml and server_instance.xml from the (windows) location C:\Users\<user>\AppData\Roaming\MySQL\Workbench (replace <user> with your own windows username) - Import in non-windows environment, for windows see above. Happy now? ;-)
[25 Oct 2021 8:42]
Mark Anderson
I echo the words of - [28 Sep 14:26] Scott Figario Fix this basic functionality people ! @Lisa Esselink - Thank you for the workaround, appreciated.
[25 Oct 2021 10:03]
Jason Alvarez
@Lisa Esselink, I can't even get to this point. The client doesn't even allow me to create the zip file. Thank you for the tip though.
[26 Oct 2021 21:58]
Adam Hyatt
So, the answer to the BACKUP is the same as the "recover" but it wasn't explicitly stated. I tried it out and it worked: BACKUP work-around for this bug: - copy these two files: connections.xml and server_instances.xml - location of these files (in windows) is: C:\Users\<user>\AppData\Roaming\MySQL\Workbench (replace <user> with your own windows username) To RESTORE: copy those above 2 files to the same location on the destination installation. caveat: I don't know where the password "vault" is kept for the connections, so you may have to re-enter those, but the connections and server list are preserved. Bonus: to restore your workspaces (all open .sql tabs, etc.) you can also copy the "sql_workspaces" directory underneath the "workbench" directory and it will restore those too!
[5 Jan 2022 6:03]
MySQL Verification Team
Bug #106036 marked as duplicate of this one
[27 Jul 2022 13:15]
Dominic Baines
Still broken. Version 8.0.29
[27 Jul 2022 13:16]
Dominic Baines
Still broken. Version 8.0.29
[13 Aug 2022 22:57]
Frédéric Trudeau
Versions 8.0.28 and 8.0.29 still broken. It's been 18 months, this ticket would need a little attention.
[17 Jan 2023 21:38]
David Hill
I had the same issue with 8.0.29 but after upgrading to 8.0.32, the issue has gone and I can now backup my connections successfully.