Mysql Transfer Record

[ear9mrn]

Hi,

Not sure if this is the right place for this. I have a mysql server on two differnet machines on the same subnet. I would like to be able to transfer a single record from one database table on one machine to an identical table on the other machine based on some criteria (eg creation date). I have been looking at using something like mysqldump or outputing an xml file of the record. Looks like both are possible athough I have not determined the exact syntax for the script yet.

Just wanted to know if this is the best method or whether there is a better way of doing it ?

Some examples would be great.

Thanks,


Pete.

[ear9mrn]

OK I manage to answer my own question.....

/usr/bin/mysql -h hostname -u username --password=password -e "select * from database.table where columname='something';" > tempfile.tmp

You have to ensure the user has the correct permissions to login from a host other than localhost. This is easy to check and fix if you have phpMyAdmin running.

and to load the record.

/usr/bin/mysqlimport -h hostname -u USERNAME -pPASSWORD -v database tempfile.tmp


Hope this is useful to someone else.

Pete.