Re: [Nolug] Looking for an automated FTP backup script for mysqldump

On Sunday 20 July 2003 11:16 am, Ron Johnson wrote:
> On Sun, 2003-07-20 at 10:35, David wrote:
> > Greetings All:
> >
> >
> >
> > I am trying to find a script that will backup the contents of
> > mysqldump to an FTP. I have found a couple of half descent scripts
> > that sort of do what I want, but none that suit me to the “T”. Since
> > there is no sense trying to reinvent the wheel, I figured someone
> > could provide some insight or point me in the right direction. Any
> > help would be greatly appreciated.
>
> Since ftp send passwords as cleartext, how about this:
>
> x=`date +%y%m%d.%H%M`
> stime=`date +%Y-%m-%d:%H:%M`
> y=`uname -n`
> db=<name_of_mysql_database>
> mysqldump | tar cvfj > /tmp/mysql_${y}_${db}_${x}.dmp.bz2
> scp /tmp/mysql_${y}_${db}_${x}.dmp.bz2 desthost:/dir/it/goes/in
>
> There's a way to config ssh/scp so that passwords are not necessary,
> while still maintaining cryptographic security. Don't know how
> to configure it, though.

This is what rsync is for, and it supports ssh.

Andy Johnson

___________________
Nolug mailing list
nolug@nolug.org
Received on 07/20/03