Hi,
IMHO:
I think the better way is to use replication between your local MySQL server
and MySQL from the Web Server.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Murray Wells" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 4:30 PM
Subject: Writing program to communicate with remote internet MySQL server?
> Hello All,
>
> For some time I've been wondering if it's possible to write a program
> that can automatically check my local MySQL server, create a recordset
> containing any new or updated records found in my local table(s) since
> the last check, and upload those new / updated records to the MySQL
> server my web site uses at phpwebhosting.com.
>
> My background is VB / VBA, but I also have access to Perl, Python and
> Ruby.
>
> I'm wondering if anyone can tell me if it's possible, using one of these
> languages, to connect to a remote MySQL server over the internet and to
> manipulate tables on the remote server as though they were recordset
> objects, similarly to how you might achieve this on a local server using
> MyODBC?
>
> The end goal is to develop a program I can fire as a Windows XP
> scheduled task to synchronize the remote database with the local one.
>
> Any help appreciated!
>
> Regards and best wishes,
>
> M Wells
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
