MySQL Forums
Forum List  »  Newbie

Re: Migrating MySql from Debian to Windows
Posted by: Bill Jour
Date: July 16, 2014 07:54AM

This is the Cron script that I found which is being run at 2 PM and 3 AM each day....(the line letters a), b), c), etc are mine)....I also changed the previous IT person's name and email address to the generic Joe Smith.).

They all make sense except for a, d, e, f, l, and m....anyone know what is going on with those lines?

Also, it is possible that he is still receiving daily database backups through email even though he is not the database administrator anymore?

a) #! /bin/sh

b) mysqldump –uwebuser –pwebuser --opt churchrecords > /sqlbackups/churchrecords.sql

c) cd /sqlbackups

d) 7zr a backup.7z churchrecords.sql

e) gpg --encrypt --recipient ‘Joe Smith’ backup.7z

f) smbmount //192.168.1.201/backups /mnt/bak/ -o username=sqlbackup,password=Passw0rd

g) Date=’date +%m_%d_%Y’

h) cd /mnt/bak

i) mkdir $DATE

j) cd /sqlbackups

k) cp backup.7z /mnt/bak/$DATE

l) umount /mnt/bak

m) #mutt –s “Offsite Record Backup” –a /sqlbackups/backup.7z.gpg joesmith@shaw.ca < /sqlbackups/mailmessage

n) rm churchrecords.sql

0) rm backup.7z

p) rm backup.7z.gpg

Options: ReplyQuote


Subject
Written By
Posted
Re: Migrating MySql from Debian to Windows
July 16, 2014 07:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.