DeepDiverMom
Programmer
What commands/parameters can I use to specify the path/directory for MySQL to look in for scripts?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I set default path for MySQL scripts
- Thread starter DeepDiverMom
- Start date
- Status
sleipnir214
Programmer
MySQL doesn't run scripts.
Want the best answers? Ask the best questions: TANSTAAFL!!
Want the best answers? Ask the best questions: TANSTAAFL!!
- Thread starter
- #3
DeepDiverMom
Programmer
Sleipnir214, Please forgive my MySQL terminological naïveté. If you don't call them "scripts", then I'll rephrase: What command do I use to specify the default path/directory for the argument of MySQL's "source" command?
Example: MySQL> source <filename>
...where <filename> is a list of one or more valid MySQL commands that I store in a file and execute as a stream via the MySQL "source" command.
I wish to avoid specifying:
source <drive:\dir1\dir2\dir3\dir4\dir5\filename.sql>
I wish to specify, instead:
source <filename.sql>
So, what MySQL specification designates
"drive:\dir1\dir2\dir3\dir4\dir5\" as the default path in which to look for a "source" argument?
Example: MySQL> source <filename>
...where <filename> is a list of one or more valid MySQL commands that I store in a file and execute as a stream via the MySQL "source" command.
I wish to avoid specifying:
source <drive:\dir1\dir2\dir3\dir4\dir5\filename.sql>
I wish to specify, instead:
source <filename.sql>
So, what MySQL specification designates
"drive:\dir1\dir2\dir3\dir4\dir5\" as the default path in which to look for a "source" argument?
sleipnir214
Programmer
If you give MySQL's source command only a filename, it will look for it in the directory from which you invoked the mysql app.
Want the best answers? Ask the best questions: TANSTAAFL!!
Want the best answers? Ask the best questions: TANSTAAFL!!
- Thread starter
- #5
DeepDiverMom
Programmer
Thanks for the confirmation of what I feared was the case. So that I don't offend the senses in the future, if one does not refer to the argument of the "source" command as a "script", what is the correct MySQL-purist term?
sleipnir214
Programmer
"script" was partially correct. It was just ambiguous -- scripts also include programming languages.
"SQL script" or "SQL command file" are probably the best terms.
Want the best answers? Ask the best questions: TANSTAAFL!!
"SQL script" or "SQL command file" are probably the best terms.
Want the best answers? Ask the best questions: TANSTAAFL!!
- Status