Re: copying rows from one MySQL server to another

2005-07-21 Thread Gleb Paharenko
Hello. Think about SELECT... INTO OUTFILE and LOAD DATA INFILE (or mysqlimport utility). If you accept the possibility to run MySQL version 5.0.x beta, you could use FEDERATED storage engine. See: http://dev.mysql.com/doc/mysql/en/federated-storage-engine.html Les Schaffer <[EMAIL

Re: copying rows from one MySQL server to another

2005-07-20 Thread Lamont R. Peterson
On Wednesday 20 July 2005 10:06am, Les Schaffer wrote: > I am working on a MySQL application where laptops will be collecting > data into local MySQL tables, and then once a week they will be > network-connected to a central server where they will "check in" their > new data and "check out" new ass

Re: copying rows from one MySQL server to another

2005-07-20 Thread SGreen
Les Schaffer <[EMAIL PROTECTED]> wrote on 07/20/2005 12:06:46 PM: > I am working on a MySQL application where laptops will be collecting > data into local MySQL tables, and then once a week they will be > network-connected to a central server where they will "check in" their > new data and "che

copying rows from one MySQL server to another

2005-07-20 Thread Les Schaffer
I am working on a MySQL application where laptops will be collecting data into local MySQL tables, and then once a week they will be network-connected to a central server where they will "check in" their new data and "check out" new assignments for data collection. given a set of rows in a set