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:
None 
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
Description:
Unable to backup connections configurations.

Error message: Backup file creation error; Could not create the backup file. Please check path and permissions and try again.

Note: destination folder has no read or write restrictions.

----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Leandro Damásio\AppData\Roaming\MySQL\Workbench\log\wb.log]
12:08:52 [ERR][      Workbench]: Console redirection failed.
12:08:52 [INF][      Workbench]: Starting up Workbench
12:08:52 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\Windows\system32
	TickCount: 5550906
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 41472000
12:08:52 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = DESKTOP-U7497NM
	USERPROFILE = C:\Users\Leandro Damásio
	HOMEPATH = \Users\Leandro Damásio
	LOCALAPPDATA = C:\Users\Leandro Damásio\AppData\Local
	PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
	PROCESSOR_ARCHITECTURE = AMD64
	CommonProgramW6432 = C:\Program Files\Common Files
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	ProgramFiles(x86) = C:\Program Files (x86)
	PROCESSOR_LEVEL = 6
	LOGONSERVER = \\DESKTOP-U7497NM
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	HOMEDRIVE = C:
	SystemRoot = C:\Windows
	SESSIONNAME = Console
	ALLUSERSPROFILE = C:\ProgramData
	DriverData = C:\Windows\System32\Drivers\DriverData
	APPDATA = C:\Users\Leandro Damásio\AppData\Roaming
	Path = C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Users\Leandro Damásio\AppData\Local\Microsoft\WindowsApps;;C:\Users\Leandro Damásio\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\Leandro Damásio\.dotnet\tools
	USERNAME = Leandro Damásio
	OneDrive = H:\OneDrive
	CommonProgramFiles = C:\Program Files\Common Files
	OS = Windows_NT
	USERDOMAIN_ROAMINGPROFILE = DESKTOP-U7497NM
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 142 Stepping 12, GenuineIntel
	OneDriveConsumer = H:\OneDrive
	USERDOMAIN = DESKTOP-U7497NM
	SystemDrive = C:
	TEMP = C:\Users\LEANDR~1\AppData\Local\Temp
	ProgramFiles = C:\Program Files
	NUMBER_OF_PROCESSORS = 8
	ComSpec = C:\Windows\system32\cmd.exe
	TMP = C:\Users\LEANDR~1\AppData\Local\Temp
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	windir = C:\Windows
	PROCESSOR_REVISION = 8e0c
	PUBLIC = C:\Users\Public
12:08:52 [INF][      Workbench]: Current version given by meta info is: 8.0.23
12:08:53 [INF][      Workbench]: Setting PATH to: C:\Windows\system32;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Users\Leandro Damásio\AppData\Local\Microsoft\WindowsApps;;C:\Users\Leandro Damásio\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\Leandro Damásio\.dotnet\tools
12:08:53 [INF][ mforms managed]: Initializing mforms wrapper
12:08:53 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	plugin path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	struct path: 
	module path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE/modules
	library path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	user data dir: C:\Users\Leandro Damásio\AppData\Roaming\MySQL\Workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
12:08:53 [INF][      WBContext]: WbContext::init
12:08:53 [INF][            WBA]: Looking for extension modules for WBA...
12:08:53 [INF][            WBA]: 0 extension modules found
12:08:53 [WRN][            grt]: Duplicate plugin name wb.tools.cmdlineClient	There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
12:08:53 [WRN][            grt]: Duplicate plugin name wb.tools.cmdlineClient	There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
12:08:53 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 8.0.23 CE build 365764 (64 bit)
	Configuration Directory: C:\Users\Leandro Damásio\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	Cairo Version: 1.10.2
	OS: Microsoft Windows 10 Home Single Language
	CPU: 8x Intel(R) Core(TM) i5-10210U CPU @ 1.60GHz, 7.8 GiB RAM
	Active video adapter Intel(R) UHD Graphics
	Installed video RAM: 1024 MB
	Current video mode: 1920 x 1080 x 4294967296 cores
	Used bit depth: 32
	Driver version: 26.20.100.8141
	Installed display drivers: C:\Windows\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_6f434727639750b3\igdumdim64.dll,C:\Windows\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_6f434727639750b3\igd10iumd64.dll,C:\Windows\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_6f434727639750b3\igd10iumd64.dll,C:\Windows\System32\DriverStore\FileRepository\iigd_dch.inf_amd64_6f434727639750b3\igd12umd64.dll
	Current user language: Português (Brasil)

12:08:53 [INF][      Workbench]: UI is up
12:08:54 [INF][      Workbench]: Running the application

How to repeat:
Tools/Configuration/Backup Connections
[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.