watice
join:2008-11-01
New York, NY | reply to TuxRaiderPen
Re: MySQL SSL and local-infile settings This is probably not the answer you are looking for. I would automate everything via CLI & bash scripts. This is my current setup. pull csv via wget, parse correctly with correct delimiters & fields, & local infile it. Setup a secure dir where your coworkers can scp their files in, & cron the parse/load on a regular basis as others suggested. If security is a concern & you'd rather not have everyone else have shell access, then... don't have everyone else have shell access! Best of luck. |
