Bug #56735 Can't restore from network share
Submitted: 12 Sep 2010 6:51 Modified: 20 Sep 2011 17:06
Reporter: Moshe Lampert Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.27 OS:Windows (7, XP)
Assigned to: Assigned Account CPU Architecture:Any

[12 Sep 2010 6:51] Moshe Lampert
from log

08:44:00 Restoring \\server\d$\file.sql

Running: mysql.exe --defaults-extra-file="c:\...\tmp3oc8ig"   --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "\\\\server\\d\$\\file.sql"

The specified path is invalid.

As you can see, the problem is on some escaping function applied on the fileshare URL.

How to repeat:
restor file from a file share on windows (you can use \\localhost for testing).

Suggested fix:
There is some type of escaping function that makes network shares broken.
[12 Sep 2010 12:50] Valeriy Kravchuk
Indeed, this is what I've got:

15:48:50 Restoring \\Dell\downloads\tmp\test.sql

Running: mysql.exe --defaults-extra-file="c:\docume~1\satell~1\locals~1\temp\tmpzw98ud"   --host=localhost --user=root --port=3310 --default-character-set=utf8 --comments < "\\\\Dell\\downloads\\tmp\\test.sql"

The filename, directory name, or volume label syntax is incorrect.

Operation failed with exitcode 1

15:49:02 Import of \\Dell\downloads\tmp\test.sql has finished with 1 errors
[13 Sep 2010 2:11] Alfredo Kojima
marked bug #56162 as duplicate
[20 Sep 2010 13:48] Johannes Taxacher
fix confirmed in release 5.2.28
[20 Sep 2010 15:56] Tony Bedford
An entry has been added to the 5.2.28 changelog:

Importing an exported file from a network share resulted in the following error due to incorrect escaping of the path:

08:44:00 Restoring \\server\d$\file.sql

Running: mysql.exe --defaults-extra-file="c:\...\tmp3oc8ig"   --host=localhost
--user=root --port=3306 --default-character-set=utf8 --comments <

The specified path is invalid.
[11 Sep 2011 17:26] Moshe Lampert
The problem still here.
It works on normal network share (\\server\share\file.sql) but not on Administrative share (\\server\d$\file.sql).

Wrong escaping: