No, it's not necessary. Check out sh man pages or a google search on sh scripting.
On Wed, 2 Mar 2005 12:49:28 +0100, anders smith <[EMAIL PROTECTED]> wrote: > Sorry about my ignorance but I can see that you now have quotation > marks around the filename.... do I need those? > > --snip--- > "/myth/mythtv_backup.`date '+%w'`.sql.gz" > --snip--- > > anders > > On Wed, 2 Mar 2005 06:36:00 -0500, cythraul <[EMAIL PROTECTED]> wrote: > > You are quite right. Cron does not like backticks. > > > > Put the line in a script: > > > > backupmythconverg.sh: > > #!/bin/sh > > /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | gzip -c > > > "/myth/mythtv_backup.`date '+%w'`.sql.gz" > > > > and add the script in your crontab. > > > > Hope this help. > > > > In the same script I have: > > > > for i in recs vids mp3 pics posters mythtv_backup*.sql.gz > > do > > echo "-- $i" > > /usr/bin/rsync -ru --delete /myth/$i/ [EMAIL PROTECTED]:/myth/$i > > echo "--" > > done > > > > Which syncs my myth directory on another machine. Automating this > > however requires the remote host to get a key. A simple howto on that > > part: > > > > http://zettai.net/Support/Howto/1099598279 > > > > good day, > > cyth > > > > On Wed, 2 Mar 2005 10:52:35 +0100, anders smith <[EMAIL PROTECTED]> wrote: > > > uuuppps!!! > > > that was supposed ot read: > > > > > > I've installed it, I can get it to work when I execute it from the > > > terminal, but when I put the same code into crontab it gives me this > > > error: > > > > > > /bin/sh: -c: line 1: unexpected EOF while looking for matching ``' > > > /bin/sh: -c: line 2: syntax error: unexpected end of file > > > > > > On Wed, 2 Mar 2005 07:56:34 +0100, anders smith <[EMAIL PROTECTED]> wrote: > > > > Thanks for the shell script. I's just what I've been looking for and > > > > haven't been able to figure out on my own... > > > > > > > > I've installed it, but I can get it to work when I execute it from the > > > > terminal, but when I put the same code into crontab it gives me this > > > > error: > > > > > > > > /bin/sh: -c: line 1: unexpected EOF while looking for matching ``' > > > > /bin/sh: -c: line 2: syntax error: unexpected end of file > > > > > > > > Anyone have a suggestion as to how I can fix it? > > > > > > > > thanks > > > > anders > > > > > > > > > > > > On Wed, 16 Feb 2005 21:07:07 -0500, cythraul <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > > > > > > > > I just thought I'd pass the knowledge... > > > > > > > > > > While my cron has been running the following for quite some time: > > > > > > > > > > mysqldump -u root -pPASSWORD mythconverg -c | gzip -c > > > > > > /myth/mythtv_backup..sql.gz > > > > > > > > > > I almost lost my DB yesterday when the volume (root in my case) filled > > > > > itself. I noticed the problem after the above command ran, thus > > > > > overwriting my DB backup. (doh!) > > > > > > > > > > Fortunately, I rsync my /myth volume weekly (which caused the problem > > > > > in the first place since /mnt was not mounted... anyway. :) and a > > > > > valid backup was still on the synced volume. > > > > > > > > > > Btw, here's the command I use to rsync: > > > > > > > > > > /usr/bin/rsync --progress -ru --delete /myth /mnt > > > > > > > > > > In order to avoid future problems, I changed the cron job for the DB > > > > > backup to: > > > > > > > > > > mysqldump -u root -pPASSWORD mythconverg -c | gzip -c > > > > > > /myth/mythtv_backup.`date '+%w'`.sql.gz > > > > > > > > > > â which will create a seven day fallback just in case. (Check out > > > > > the > > > > > man page of date for more option like %w -- %w = weekday where > > > > > 0=sunday.) > > > > > > > > > > In the hopes that some potentially poor soul will implement something > > > > > similar on their system. :) > > > > > > > > > > And, that make me think, would it not be a good idea to have something > > > > > directly in Myth to deal with DB backups or should it be handled > > > > > purely outside like my cron job...? > > > > > > > > > > Hasta, > > > > > cyth > > > > > > > > > > > > > > > _______________________________________________ > > > > > mythtv-users mailing list > > > > > mythtv-users@mythtv.org > > > > > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > mythtv-users mailing list > > mythtv-users@mythtv.org > > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users > > > > > > >
_______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users