Merging Tables with renumbering primary key

I have a set up where data will be collected on several local machines, and then needs to be merged into a single database on a data storage server. I have two tables that have auto_incrementing ids that I don't want to clash when merging, and another table that uses one of these autoincrementing numbers as a key that would need to be changed when transfered to the storage server.

The tables look like: d

data__ProcessedDataFrames
data__RawDataFrames
data__Raw_in_Processed (this has a key into data__ProcessedDataFrames on

mysql> desc data__ProcessedDataFrames;

+------------------------+------------------+------+-----+---------+----------------+

| Field                  | Type             | Null | Key | Default | Extra 

        |
+------------------------+------------------+------+-----+---------+----------------+

| processed_id           | int(10) unsigned | NO   | PRI | NULL    |

auto_increment |

| top_level_product_name | varchar(255)     | YES  | MUL | NULL    |       

        |

| test_id                | int(10) unsigned | YES  | MUL | NULL    |       

        |

| payload_time           | double           | YES  | MUL | NULL    |       

        |

| universal_time         | double           | YES  |     | NULL    |       

        |

| processed_data         | mediumblob       | YES  |     | NULL    |       

        |
+------------------------+------------------+------+-----+---------+----------------+

mysql> desc data__RawDataFrames;

+--------------+------------------+------+-----+---------+----------------+

| Field        | Type             | Null | Key | Default | Extra          |

+--------------+------------------+------+-----+---------+----------------+

| raw_id       | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| test_id      | int(10) unsigned | NO   | PRI | 0       |                |
| payload_time | double           | YES  | MUL | NULL    |                |
| raw_data     | blob             | YES  |     | NULL    |                |
| frame_name   | varchar(100)     | YES  | MUL | NULL    |                |

+--------------+------------------+------+-----+---------+----------------+

mysql> desc data__Raw_in_Processed;

+--------------+------------------+------+-----+---------+-------+

| Field        | Type             | Null | Key | Default | Extra |

+--------------+------------------+------+-----+---------+-------+

| processed_id | int(10) unsigned | NO   | MUL |         |       |
| frame_name   | varchar(100)     | YES  |     | NULL    |       |
| payload_time | double           | YES  |     | NULL    |       |

+--------------+------------------+------+-----+---------+-------+

mysql>

Again each individual box will be collecting data separately, and when we decide to store the data we need to merge it onto a storage server into the same database.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

Are there some docs out that that could be helpful or any tips from anyone?

D$

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