backup between two servers on diferent boxes

[sfullman]

Hi There,

I have a series of mysql tables - assume that they are receving data CONSTANTLY. All insert into, no select, so these tables are NOT indexed. They have an auto-increment primary key, and also a TimeStamp field, but no indexes.

Now, enter a new server also running mysql. I want to, periodically, copy all of these tables from one physical server to another physical server without interrupting data receipt on the first server.

This is new to me. I know there's a lot of experience out there on this forum on the most elegant way to do it - calling on mysql skills but also perhaps using CRON (which I've done and can implement). Thanks

[bradgrafelman]

Have you looked into Replication ?

Also:

sfullman wrote:

All insert into, no select, so these tables are NOT indexed. They have an auto-increment primary key

You just contradicted yourself there. An AUTO_INCREMENT column is required to be indexed (a PRIMARY index, that is). :p

[zypher11]

See i would have immediately said "Cron Job" but that's primarily because im too lazy to ready 500 pages to learn how to use the mysql replication process :p