Hi,

I am running a daily script that backup my mysql db.
I want to upload my backup folder to my ftp server, everyday.

How can I do it?

Thanks,
Assaf

i'd use scp to transfer the file, there's a good article about passwordless ssh here

http://www.hackinglinuxexposed.com/a.../20030109.html

otherwise, this'll do it via ftp with perl:

#!/usr/bin/perl -w

my $username = 'user';
my $password = 'pass';
my $host = 'host';
my $file = 'file.tgz';

open(FTPHOST, "|ftp -n $host\n");
print FTPHOST "user $username $password\n";
print FTPHOST "bin\n";
print FTPHOST "prompt off\n";
print FTPHOST "put $file\n";
print FTPHOST "exit\n";
close(FTPHOST);

This is what I'm currently doing in crobtab and it works fine for me. I had to install LFTP. If you have /usr/local/bin in your path then you can take out those two lines.

I'm a bit cautious by nature so take out the IF THEN statements. Also modify the mydate to whatever output you like.

I'm still trying to work out a way to disconnect users from the DB before I do a mysql dump b/c once I had a table that got locked "in use" and killed the backups (had to fix the table b4 I got it working again).

#! /bin/bash
mydate=$(date +%m%d%Y%l%M%p)
PATH=$PATH:/usr/local/bin
export PATH

/usr/local/mysql/bin/mysqldump --flush-logs --opt -u SQLUSER -pSQLPWD dbname > /dir1/dir2/dir3/backup.sql
cd /dir1/dir2/dir3/
if [ -e backup.sql ]
then
tar -czvf backup-$mydate.tar.gz backup.sql
fi
if [ -e backup-$mydate.tar.gz ]
then
lftp <<EOF
open FTPSERVER
user FTPUSER FTPPWD
pwd
put backup-$mydate.tar.gz
bye
EOF
fi
if [ -e backup-$mydate.tar.gz ]
then rm /dir1/dir2/dir3/backup.sql
fi