Transfer Data

[Mike Siconolfi]

Hello,

i need to be able to transfer data from a table on another DB server to a local DB. CUrrently the process is querying the table for the last date:

SELECT from_unixtime(timestamp) FROM DB1.table order by from_unixtime(timestamp) desc limit 1

2012-03-21 12-23-56

Now i need to use that to import from another DB located off site everything from that date on into the local DB for that table.

SELECT * FROM DB.table where from_unixtime(timestamp) > '2012-03-21 12-23-56'

What i dont know how to do is actually do this all from a query browser on my local DB automatically without me having to input the date manually.