Backup DB from one server to other

[Anon]

I have two linux servers, with the same environment.

Now I will backup the DB from one server to other by manual. Can I do it automatic??
This mean everyday at the same time, the DB files will automatic copy from one server to others.

May anyone tell me the method? Thanks a lot!!

[Anon]

You could always use mysqldump, scp/ssh and a cronjob to automate the backups.

The way I think of it you have a script that
-dumps the database
-copies the dump to the backup server via scp
-calls a script (via ssh) on the backup machine that updates the database from the file that was just scp'ed.

all controlled by crond.

I've heard a bit about replication but I'm not sure if this is what replication is for.

[salmon]

You could just pipe the outpt of mysqldump direcly into mysql (if your remote mysql server allows remote connections)

use the command:

mysqldump local_dbName | mysql -h remoteHost -u remoteUser -pPassword remote_dbName

and set up a CRON job to do it automatically.