Hai..
Iam having two servers with redhat9.0 loaded on both.Iam using mysql as my database.One server is being kept as a backup server.
My problem is that ,I want a script which is to be executed in such a way that it takes bakup of my database automatically in the scheduled time and transfer it to my backup server.
In nutshell how to execute a script on a scheduled time say 5:00 PM every day,and how to transfer it to another machine which in the network.

Expecting ur valuable suggestions
With regards
Hari

I can't write the script for you, but you need to schedule it with cron.

Add a line to /etc/crontab (You will need to be root), such as:
This means that the script is run at 5pm, every day.

man cron for more details

--Ian

If you're using KDE, there's a nice GUI frontend called "kcron."

Thanx for ur reply..

Ok so scheduleuing can be done using crond ,but is it posible to copy a particular file to another network machine (also rh9.0) automatically i mean in the same script .i.e once backup is taken in the scheduled time i want to copy that to another machine automatically.

I would share out the destination folder of your other RH9 machine and mount it on your primary RH9 machine where the database files reside. Then it's a simple matter of copying the files to the shared partition.

That's exactly how I back up my mail archive files on a weekly basis.

Hai..
Thanks for the reply..

but as iam a newbie in linux i couldnt get all that u ve said .how can i share it did u mean by using SAMBA server or anything like that.and oce its shared how to mount it..

Thanks in advance

You need to run a service called "nfs" on the machine that shares out the partition. Samba is for sharing your Linux partitions with Windows clients. Between Linux machines, all you need is NFS ("nfs").

http://nfs.sourceforge.net/nfs-howto/server.html

Once you have your destination folder shared out on the second machine, you use the "mount" command on the primary machine to mount it. For instance:
This mounts the shared folder "/share" of your second machine (which I arbitrarily call "rh9-2") on your primary machine as /mnt/share. If you're familiar with Windows folder sharing, it's something like this:
Run "man mount" to see more details about the "mount" command.

Here is a Linux-Gazette article which contains a mysql backup script using a php script. If you use something like this, make sure that the script is not world readable, since it contains passwords.

oh thanx a lot this was realyy elaborate replyy..
Thanku very much 4 ur help.