MySQL Forums
Forum List  »  Backup

transfer mysqldump backup via SSH
Posted by: sebastian suarez
Date: March 21, 2006 06:39PM

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.-

Options: ReplyQuote


Subject
Views
Written By
Posted
transfer mysqldump backup via SSH
16717
March 21, 2006 06:39PM
7210
March 26, 2006 03:13PM
10191
March 26, 2006 06:09PM


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.