In plesk , I wish to have a backup cron job, ftp back up file to another ftp server?

muskiediver · 11-23-2006, 09:03 AM

I have this cron job (currently testing):

30 17 * * * mysqldump -h mydomainip -u myusername -mypassword --add-drop-table -n --databases mydatabasefile >"/var/www/vhosts/mydomain/database$(date +%g%m%d_%H%M).sql"

What I would like to so is ad a part that would allow me to have these files automatically ftp'd to another ftp server in another location? Any suggestions please?

unSpawn · 11-24-2006, 05:28 AM

1. Move your backup command to a file, call the file "/etc/cron.daily/backup-sql-ftp.cron".
2. Change the crontab entry to "30 17 * * * /etc/cron.daily/backup-sql-ftp.cron".
2. Contents of the file "/etc/cron.daily/backup-sql-ftp.cron":

Code:

#!/bin/sh
FTP_USER='your_ftp_accountname'
FTP_PASS='your_ftp_password'
DUMP="/var/www/vhosts/mydomain/database$(date +%g%m%d_%H%M).sql"

mysqldump -h mydomainip -u myusername -mypassword --add-drop-table -n \
--databases mydatabasefile >"${DUMP}"; [ ! -s "${DUMP}" ] && exit 1

ftp ftp.so.me.ho.st <<EOC
user $FTP_USER
$FTP_PASS
cd /upload/dir
put $DUMP
quit
EOC
exit 0

3. Test by running "sh /etc/cron.daily/backup-sql-ftp.cron".

* I think this should have been tacked on to http://www.linuxquestions.org/questi...d.php?t=504224 since that's where this all started. Keeping your questions and posts about the same subject together makes it easier for others to follow instructions. If you agree ask the mods of this forum to merge these two threads.

muskiediver · 11-25-2006, 06:41 AM

Just so I am understanding your post. Where do I put my username and password (on the ftp part)?

This will be very cool if I can get it working.

unSpawn · 11-27-2006, 04:07 AM

See the first two variables in the script, replace "your_ftp_accountname" and "your_ftp_password" with the actual login and pass.

storpappa · 12-19-2006, 12:44 PM

I checked out the other thread...seems this thread is in the area of what I need to do

I need to backup all of the contents of /home
I need to backup of the mysql databases

But some of the scripts to make the transfer and storage easier make a tar of the contents. Disk space today can handle that, but as the sites grow, I see that being a tough fit. Guess I can deal with that when it happens later.

And I came across one script that fired of an email at the end of each backup. Wish I had bookmarked it.

I'll post what I finally dig up, but I need to run a cron job calling a ftp backup script. Just a matter of finding one with a few bells and whistles

djingo · 02-08-2009, 10:55 AM

Quote:

Originally Posted by unSpawn

1. Move your backup command to a file, call the file "/etc/cron.daily/backup-sql-ftp.cron".
2. Change the crontab entry to "30 17 * * * /etc/cron.daily/backup-sql-ftp.cron".
2. Contents of the file "/etc/cron.daily/backup-sql-ftp.cron":

Code:

#!/bin/sh
FTP_USER='your_ftp_accountname'
FTP_PASS='your_ftp_password'
DUMP="/var/www/vhosts/mydomain/database$(date +%g%m%d_%H%M).sql"

mysqldump -h mydomainip -u myusername -mypassword --add-drop-table -n \
--databases mydatabasefile >"${DUMP}"; [ ! -s "${DUMP}" ] && exit 1

ftp ftp.so.me.ho.st <<EOC
user $FTP_USER
$FTP_PASS
cd /upload/dir
put $DUMP
quit
EOC
exit 0

3. Test by running "sh /etc/cron.daily/backup-sql-ftp.cron".

* I think this should have been tacked on to http://www.linuxquestions.org/questi...d.php?t=504224 since that's where this all started. Keeping your questions and posts about the same subject together makes it easier for others to follow instructions. If you agree ask the mods of this forum to merge these two threads.

I can create the file alright, but I am getting this error when trying to upload:

This security scheme is not implemented
This security scheme is not implemented
KERBEROS_V4 rejected as an authentication type
Password:Name (xxxx):
Login authentication failed

I can connect fine to ftp with a windows client.

Sureshan · 07-16-2009, 03:13 AM

Hi unSpawn

Thank you for the script.

I need the very same solution but I need the files that are being transferred not to be zipped. Can you advise as to how this could be done?

Many Thanks