Writing paths in Mysql

MarkH2 · April 11th, 2008, 01:13 PM

This is probably a very simple problem but one I've got stuck on.
I just started learning Mysql. An example exercise needs me to put in the path to a text file with a .sql extension. I put in the full path c:\ etc. but the prompt says it cannot find the file. Is there any particular convention in putting the path in ?
The code as I wrote it is:
c:\program files\mysql\mysql server 5.0\bin\mysql < C:\program files\mysql\user_info.sql

thanks

Mark

ciderpunx · May 13th, 2008, 08:53 AM

*heh*

You're using windows, right? Try something like:

Code:

type C:\program files\mysql\user_info.sql | c:\program files\mysql\mysql server 5.0\bin\mysql

Or maybe:

Code:

c:\program files\mysql\mysql server 5.0\bin\mysql C:\program files\mysql\user_info.sql

I'm afraid I don't have a windows box on which to experiment at the moment

Cheers

--
Charlie Harvey's website - linux, perl, java, anarchism and punk rock: http://charlieharvey.org.uk