transfer mysqldump backup via SSH
Hi all,
Im using a cron job to backup some of my servers into a local dir. in each box every night.
Im trying to figured out the way to set those backup jobs been stored into a one of the servers directory.
This is one of my crons.
# mysqldump -u root -password databsename > /localdir/file.sql
Is there any way this cron can point to a root@localhost:/directory without the root password prompt?
Many thanks and sorry if im been too newbie!
Seb.-
Subject
Views
Written By
Posted
transfer mysqldump backup via SSH
16724
March 21, 2006 06:39PM
7214
March 26, 2006 03:13PM
10196
March 26, 2006 06:09PM
6104
April 13, 2006 11:25AM
8119
April 14, 2006 08:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.