List:General Discussion« Previous MessageNext Message »
From:Peter Lauri Date:June 6 2006 2:17am
Subject:RE: UPDATE from one server to another
View as plain text  
I am not that clever, but I would just create a Web Service (WS) on the
Server that the Laptop call whenever the laptop want to push the date into
the server database.

I heard something about something called rsync, but I think that is
restricted to Linx, Unix.

/Peter

-----Original Message-----
From: Jason Dimberg [mailto:jason.dimberg@stripped] 
Sent: Tuesday, June 06, 2006 10:35 AM
To: mysql@stripped
Subject: UPDATE from one server to another

I am working on an application where data will be collected on laptops 
and then uploaded to a central database once the laptop is able to 
connect to the network after being in the field.  I was initially 
thinking of using MS Access as a front end with linked tables through 
MySQL ODBC.  I am now considering running WAMP on each machine with a 
web interface because there will be no interoperability issues if MySQL 
is the db server on both ends, but I am 1.) looking for any 
recommendations for the laptop interface (MS Access/WAMP or whatever 
other options might be available) and 2.) want to know what is the 
actual command for updating a table across two servers (this is NOT 
replication, but merely updating new data to an existing table).

Data transfered will include binary objects and possibly GIS data.

For example, Laptop 1 might have 10 rows of data from todays activities 
that need to be added to the main Server.  Laptop 2 might have 30 rows 
of data that need to be added to the main Server.  Neither laptop needs 
to have the data from the other, but the Server will contain data from 
both Laptops at the end of the day.  The Server will then offer the data 
through a web interface.

Server:
Linux/MySQL 5.0

Laptops
MS Access 2003 OR
MySQL 5.0/ PHP 5/ Apache 2

Thank you.
-- 
Jason


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
UPDATE from one server to anotherJason Dimberg6 Jun
  • RE: UPDATE from one server to anotherPeter Lauri6 Jun
  • Re: UPDATE from one server to anotherDaniel da Veiga6 Jun
    • Re: UPDATE from one server to anotherJason Dimberg7 Jun
  • Re: UPDATE from one server to anotherDaniel Kasak7 Jun
RE: UPDATE from one server to anotherTim Lucia6 Jun
  • RE: UPDATE from one server to anotherPeter Lauri6 Jun
RE: UPDATE from one server to anotherTim Lucia6 Jun