updating Mysql database

[jammy]

I have to update a Mysql database on the client side from mine, also Mysql. The amount of data to update/insert is around 2G and i've to do it twice a day.

how to do it??
give suggestions -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[capricorn]

buddy
Look into using mysqlhotcopy. I'm not sure if that would be the best to do the job or if there was another product out there. I believe the mysql.com website has info on mysqlhotcopy.
hope it helps -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[rebel]

hi jammy,I use mysqlhotcopy and it worked fir me. I don't have any dbs > 2 gb however.
I've read of other options to sync those databases in almost real time, but can't remember at this moment . -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --