Absolutely it is possible (With cavaets).
The cavaets are...
1. Does you web hosting company allow external access to your MySQL
database. I do not know for sure but it looks like they might (telnet works
to port 3306).
2. Is your Mysql user set up to allow external access.
3. If you are going to try to synchronize the tables yourself. Not an easy
task. My 3 suggestions to you for this are:
a. Whenever your application changes the database, log the changes to a
separate table. (Not really reliable since you can change the tables in the
MySQL client program that would never get logged).
b. Write a program that checks every record in the 2 seperate database,
making changes when you find them. (not very fast).
c. Turn on the bin-log on your local server, then issue the same commands
to the remote server. (Most definately the way to go.)
As for your question on how to do it on the remote server. Since you are
already familiar with VB/MyODBC the that is definately the way to go. Just
create a separate DSN for the remote server and use whatever tool you are
familiar with to do the updates.
Hope this helps.
Roger
-----Original Message-----
From: M Wells [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 9:32 AM
To: [EMAIL PROTECTED]
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
