Re: ISP Hosted database

"Petr Vileta" <[email protected]> Sat, 21 Oct 2006 02:05:56 +0200
Newsgroups gmane.comp.db.mysql.windows
Message-ID <008a01c6f4a5$a8e7c2e0$6401a8c0@petr1>
----- Original Message ----- 
From: "Vic Spainhower" <[email protected]>
To: <[email protected]>
Sent: Saturday, October 21, 2006 1:11 AM
Subject: ISP Hosted database


> Hello,
>
> I've built a web site for receiving entries for shows (type of show 
> doesn't
> matter could be horse, dog, cat, car etc.) . These show entries are stored
> in a MySQL database. When an entry is received the information is not only
> captured in the MySQL database but it is also emailed to the Show 
> Secretary.
> The Show Secretary has an Access Database that can connect to the web site
> and pick up these entries which are then copied to the Access database.
> That's the 30,000 foot picture of what's going on.
>
You can to write some backend script in PHP. I precede that your ISP allow 
to run PHP pages. This script should to have at least two functions.
First function would be for downloading data from server to local Access 
database in some acceptable form, eg. data dump, XML or CSV.
Second function would be for data uploading to server analogous to previous 
function.
I know, it is not ideal, but for dialup users this should be a solution.

Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail 
from another non-spammer site please.)



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]