Ask our mutual friend, Google.  It has lots of answers for you. 

-----Original Message-----
From: Peter Lauri [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 06, 2006 10:09 AM
To: 'Tim Lucia'; 'Jason Dimberg'; mysql@lists.mysql.com
Subject: RE: UPDATE from one server to another

Can you run rsync on Windows environment?

-----Original Message-----
From: Tim Lucia [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 6:32 PM
To: 'Peter Lauri'; 'Jason Dimberg'; mysql@lists.mysql.com
Subject: RE: UPDATE from one server to another

rsync is a *nix utility that synchronizes two file systems, one local and
one remote (typically).  It is used to produce mirrors / backups / etc.  You
would not want to use it to synchronize database (raw) files via the file
system.

If you include a timestamp field, you can use that to copy across all
records that are newer then the last time you uploaded, or, greater then the
most-recent date in the main database.

Tim

rsync                (1)  - faster, flexible replacement for rcp

DESCRIPTION
      rsync  is  a  program that behaves in much the same way that rcp does,
      but has many more options and uses the rsync remote-update protocol to
      greatly  speed  up  file  transfers when the destination file is being
      updated.

      The rsync remote-update protocol allows rsync  to  transfer  just  the
      differences  between  two sets of files across the network connection,
      using an efficient checksum-search algorithm described in the  techni-
      cal report that accompanies this package.


-----Original Message-----
From: Peter Lauri [mailto:[EMAIL PROTECTED]
Sent: Monday, June 05, 2006 10:17 PM
To: 'Jason Dimberg'; mysql@lists.mysql.com
Subject: RE: UPDATE from one server to another

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:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 10:35 AM
To: mysql@lists.mysql.com
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/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to