|
Home > Archive > Unix Shell > October 2006 > automate csv upload to mysql database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
automate csv upload to mysql database
|
|
| jsamdirect 2006-10-17, 1:24 pm |
| I am tring to automate the process of uploading data from a csv file to
a mysql database. The issue is I am using a shared hosting services so
I cannot connect directly to the mysql server from anything other then
a webpage on the hosted server.
I know I can automate uploading the csv file to the web server, so
next, how can I automate importing the data into the mysql database. I
don't have shell access to the server, so I guess I need to come up
with another way, may be PHP, but I cannot schedule anything to run on
the server. I wonder it there is a way to execute script on my
workstation that can tell a php (or other) page to do the import?
Any thoughts?
| |
| Passer By 2006-10-26, 1:15 pm |
| "jsamdirect" <support@jsamdirect.com> writes:
> I am tring to automate the process of uploading data from a csv file to
> a mysql database. The issue is I am using a shared hosting services so
> I cannot connect directly to the mysql server from anything other then
> a webpage on the hosted server.
>
> I know I can automate uploading the csv file to the web server, so
> next, how can I automate importing the data into the mysql database. I
> don't have shell access to the server, so I guess I need to come up
> with another way, may be PHP, but I cannot schedule anything to run on
> the server. I wonder it there is a way to execute script on my
> workstation that can tell a php (or other) page to do the import?
>
> Any thoughts?
so you can speak with php script on the page with `curl` maybe.
|
|
|
|
|