Re: db backup script in gentoo

On Saturday 29 November 2008, "Andrus" <kobruleht2(at)hot(dot)ee> wrote:
> How to create automated backup script in Gentoo which in every night 3:00
> PM backups one database and sends backup
> with ftp using unique file name?
>
> In windows I can use scheduler and script
>
> set FILENAME=%DATE:~8,4%%DATE:~5,2%%DATE:~2,2%MyDbBackup
> pg_dump -Z6 -b -v -f "%FILENAME%.backup" -F c -h localhost -U postgres
> mydb ftp -send -u username -p password "%FILENAME%.backup"
> ftp.backupserver.com
>
> I have few experience in Linux. How to convert this to Gentoo Linux ?

Investigate the date command, shell scripting in general, the ncftp program
(specifically its ncftpput command), and cron.

If you're that unfamiliar with Linux, though, I would very strongly suggest
not using Gentoo.

--
Alan