Newbie MySQL question about paths
Posted: Sun Jan 18, 2009 4:37 am
I'm trying to use mysql cli in Windows to read a source sql file and run the queries therein.
I run this command:
When I do this, it treats every backslash as a command starter... it says that \x and \m are not valid commands, then shows a status, then tries to clear the command, then does the notee command... How do I a build a path in mysql without it reading the backslashes as command starters? I tried enclosing the path in single quotes, and tried enclosing she slashes in single quotes and neither worked. Is there some other way to make the path string literal?
If I move and rename the file and run the command again:
It will work after still telling me that \m is not a valid command twice.
I'm sure it's just such an elemental thing that Google failed me on this one...
Thanks for any help!
I run this command:
Code: Select all
source c:\xampp\mysql\sql_files\common\tables.sql;If I move and rename the file and run the command again:
Code: Select all
source ..\m\m.sql;I'm sure it's just such an elemental thing that Google failed me on this one...
Thanks for any help!