MySQL source command help

Forum Moderators: open

Message Too Old, No Replies

MySQL source command help

andrewsmd

3:10 am on Feb 4, 2009 (gmt 0)

I have installed mysql on my machine at home. I dumped my data from another database to a file called db.sql. I want to load it into my database at home. I've tried using the source command with the path of the file but it says it cannot find the source. Here is my syntax
source 'c:\documents and settings\some folder\db.sql' I know the path is right but it says it cannot find it. I have tried without the quotes and that does not work either. How can I get this into my database. Thanks.

coopster

2:41 pm on Feb 4, 2009 (gmt 0)

double up on your path slashes on a Windows system.

andrewsmd

3:21 pm on Feb 4, 2009 (gmt 0)

That was it. I never thought about escaping the characters. One weird note, I had to escape everyone but the first one. Like this C:\documents and settings\\some folder\\db.sql don't know why. Thanks for your help.