Hi,
If i undertsand well you wish to make an application which to
synchronization data between your local MySQL with the MySQL which is on the
Web Server.
I think you must have distinct connection to be able to pass the data from
one server to other.
I think you can do this with VB(..using ADO-MyODBC) or Perl.I don't know
about Python or Ruby if have facility to accesing MySQL using MyODBC or if
have something like MySQL database driver.
Another option for VB is to use GMySQL (MySQL API for VB).In samples you
will find a code which is "near" with your requirment.
You can download it from :
http://www.a1vbcode.com/app.asp?ID=1764
I hope it help.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "M Wells" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 24, 2003 11:32 AM
Subject: RE: Writing program to communicate with remote internet MySQL
server?
> Hi Gelu,
>
> I agree with you, and it's an excellent suggestion.
>
> On the other hand, I am generally interested in whether or not it's
> within my abilities / available toolset to do this, and it would allow
> me to develop far more specific / personalised 'synchronisation'
> processes.
>
> Anyone have any thoughts on how this could be achieved?
>
> Regards and best wishes,
>
> Murray Wells
>
>
> -----Original Message-----
> From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 24 January 2003 7:24 AM
> To: Murray Wells; [EMAIL PROTECTED]
> Subject: Re: Writing program to communicate with remote internet MySQL
> server?
>
> 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
>
>
>
>
> ---------------------------------------------------------------------
> 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
