ckroon
Posts: 869
|
| Posted: 07/17/2007, 2:04 PM |
|
Hi all..
This is off topic...I think...
I have a client who wants to set up the Mysql GUI program to run a scheduled batch job that runs a query, then uploads it to a remote internet folder that users can access.
They are using Navicat which ask you to point it to a network drive, but I can't configure anything that is not on a local network.
Know of any apps that can handle this?
Can codecharges' report feature do something like this?
Thanks!
_________________
Walter Kempees...you are dearly missed. |
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 07/17/2007, 8:18 PM |
|
ckroon
Can you give us a little more information like the environment you are working with as well as the development language of choice??
|
|
|
|
ckroon
Posts: 869
|
| Posted: 07/17/2007, 8:46 PM |
|
Certainly
Mysql/php
_________________
Walter Kempees...you are dearly missed. |
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 07/17/2007, 9:14 PM |
|
ckroon
Is the OS Linux, Unix or Windows??
|
|
|
|
ckroon
Posts: 869
|
| Posted: 07/17/2007, 9:24 PM |
|
Linux/ Fedora Core 6
_________________
Walter Kempees...you are dearly missed. |
|
|
|
Wkempees
|
| Posted: 07/18/2007, 4:33 AM |
|
Is it a static query, or is it prone to be changed often?
What schedule? daily weekly or multiple times per day?
check out:
cron, the Linux tool for scheduling.
creste a mysql script to be run by mysql cli, stuff that in a cron job
OR
create a CCS page, with the sql and fileput logic in the before show.
The page could have minimal html like, job running.
have that page called at interval.
There is a php scheduled job explan ation somewhere on the internet
google it.
"php scheduled job"
http://www.dwalker.co.uk/phpjobscheduler/
http://www.faqts.com/knowledge_base/view.phtml/aid/34376/fid/51
http://www.webmasterworld.com/forum88/4652.htm
"mysql scheduled job"
more interesting mysql 5.1.6
http://dev.mysql.com/tech-resources/articles/event-feature.html
or have Navicat do the work.
On a win pc address the remote db.
do the job
and on the pc do a ftp of the file to the remote
this could be a scheduled batch job, checking for file exist
if exist ftp it, rename
and loop
Walter
|
|
|
|
Wkempees
|
| Posted: 07/18/2007, 6:59 AM |
|
"=E4ddress the remote db"
several scenarios:
if the database is on an intranet or local network, you or the customer=20
will surely know how to connect to the db.
if the database is on a hosted platform, i.e. hosted by an ISP you=20
probably have two choices, either the database is =F6pen" to all or=20
certain remote addresses (least likely) or it is addressable only from=20
within the domain of the user (localhost as seen by the webserver; most=20
likely).
In the last scenario you have to use the HTTP tunneling available in=20
Navicat, both other scenarios you can connect directly.
In our hosting plans we allow the customer to define open or closed=20
connections, in the case of an open connection the ip address can be=20
limited (to one or a range).
Walter
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 07/18/2007, 2:48 PM |
|
Wkempees
I don't think that I could have stated it any better...
|
|
|
|
|
