Using MySQL for Exchange Rate Updates
"But to get MySQL to read the files my bash script makes, they have to be in the database's money directory. Actually, the command load data local makes it possible to input mass data easily. The MySQL programmers turned off this command, however, because they judged it to be a security risk. Supposedly it is possible to turn the command back on, but I was not able to get it to work. Therefore, I had to hack around it. I found that I can make load data work when the input file is inside the same dir as the mysql table is. My dir path is /var/lib/mysql/money/."
(Submitted by Noel Sat Jun 12, 2004 )
Our content can be syndicated: Main page Mac Page
Copyright 1999-2005 Noel Davis. Noel also runs web sites about sailing and kayaking.
All trademarks are the property of their owners.
All articles are owned by their author