ISFDB talk:MySQL Only Setup

From ISFDB
Jump to navigation Jump to search

Formatting of source statement

There's something funny about the "source" step under Windows. It's only the semi-colon that causes an error: the slashes versus back-slashes are not a problem. This fails:

source H:\ISFDB\backup\partial;

But

source H:\ISFDB\backup\partial

works, as does

source H:/ISFDB/backup/partial;

and this

source H:/ISFDB/backup/partial

May just be my old version of MySQL, of course. BLongley 21:45, 3 November 2008 (UTC)

I recall that MySQL's documentation (at least the version that I used originally) explicitly stated that we should use forward slashes under Windows. If backslashes work under some versions of MySQL, I suspect that it's an unsupported feature and may not be reliable. Ahasuerus 21:50, 3 November 2008 (UTC)
MySQL has DOCUMENTATION!?!?!? 8-O BLongley 22:19, 3 November 2008 (UTC)
Yep - see http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html
Of course, the manual for source seems to be wrong as they suggest using / or \\ with the latter not working for me. I'm running version 5.0.41-community-nt and have the same results as Bill with source d:\\Data\\partial; giving an error and the other forms, including source d:\\Data\\partial working. -Marc Kupper|talk 03:35, 4 November 2008 (UTC)