Need a script spanning two servers suggestion.

I have a new situation I'm facing and could use a suggestion or two, as
I don't seem to be able to think in the abstract very well.

We have a local server which holds all of our image files.
We have a remote server that runs our public Web server and mySQL
database.
I need to be able to run a script that will:
Read the contents of a dir on the local server and
a. make thumbnails of the files in it
b. querey the database and pull information on each file based on the
filename
c. create a spreadsheet and e-mail it to 3rd parties

Now, I know how to do each of those things, don't need help there.
I just need a way to get it to span the two servers.

Here's what I was thinking:
1. Have the PHP script on the local server which processes the files
and sends the file names it processed...
2. Through a GET in a WGET back to another PHP script on the remote
server which pulls the database info for those filenames and creates
the spreadsheets/emails

or

1. Have the PHP script on the local server which processes the files
and sends the file names it processed to a local text file named with a
timestamp.
2. Then it initiates a WGET to a PHP script on the remote server
sending that filename in a GET which tells the remote script where to
find the list of filenames it needs to pull the information for from
the DB and generate the sheets/emails

or

1. Keep a constantly backed up version of the remote database on the
local server via SCP's of the exported database
2. Have the PHP script on the local server process the files AND do all
the DB queries and sheets/emails from the version of the DB that's been
backed up to it on a regular basis

What do you think? Or is there a better way that I'm just not thinking
of?
Thanks for any feedback!
Liam

.

Relevant Pages

  • Re: DTS
    ... If you need to transfer the entire database from remote to local, ... Copy the MDF and LDF to LOcal server ... > I wanna copy the remoted database into local database through DTS. ...
    (microsoft.public.sqlserver.clients)
  • Re: backup problem
    ... The problem occurs when backup target media is not formatted or not ... please run the following command to test the database. ... Please installed the following Hotfixes on local server. ... By using Eseutil /d to defragment a database, ...
    (microsoft.public.exchange.admin)
  • Re: Delphi 7 Lite -- Big Big Money for Borland
    ... Alan Garny wrote: ... Advantage Database and including the local server. ... I've worked with many 3rd party solutions including Oracle, SQL Server, ...
    (borland.public.delphi.non-technical)
  • Re: [PHP] phpPgAdmin
    ... Is there a way via PhpPgAdmin to export/import the whole database ... Because i developed my database on local server and now i want to ... postgresql administrative user account for doing backup? ... then you can restore backuped data in any postgresql server. ...
    (php.general)
  • Re: Fatal error: session_start(): Failed to initialize storage module: user
    ... local server on my lan), and all of a sudden I get: ... combination with a database, so you might check wether that database is ... It's not saving to a database, it's creating a session file. ... And as stated in my question there is no "hoster", it's my lan server, ...
    (comp.lang.php)