SmtC: Show me the Code
Ole Peter Smith
Instituto de Matemática e Estatística
Universidade Federal de Goiás
http://www.olesmith.com.br

2018
O Homem é a espécie mais insana.
Venera um Deus invisível e destrói a Natureza visível…
Sem se aperceber de que esta Natureza, que ele destrói,
é o Deus invisível que ele venera
Hubert Reeves
< Backup MySQL | Backup Script | SSH >

My Database & File Distributed Backup Cron Job

Real men do not do backup...

  • A little magic script: login to remote host via SSH - or run command there.
  • Save code below in: /usr/local/bin/ssh.py
  • # ln -s /usr/local/bin/ssh.py /usr/local/bin/gauss
  • # ln -s /usr/local/bin/ssh.py /usr/local/bin/ole@gauss
Python Listing: ssh.py.
#!/usr/bin/python

import os,sys,re

##Get hostname from command name.
##Should be soft link to this script.

args=sys.argv
command=args.pop(0)
command=command.split('/')

host=command.pop()

user=""
srch=re.search('(\S+)\@(\S+)',host)
if (  re.search('(\S+)\@(\S+)',host)   ):
   user=srch.group(1)+"@"
   host=srch.group(2)

command=[
   "/usr/bin/ssh",
   "-X",
   user+host,
]+args

res=os.system(   " ".join(command)   )
  • root@gauss:~# grep ocean /etc/hosts
    67.207.88.206 ocean
    root@gauss:~#
  • root@gauss:~# ocean df
    Filesystem 1K-blocks Used Available Use% Mounted on
    /dev/vda1 61797116 10922488 47712680 19% /
    udev 10240 0 10240 0% /dev
    tmpfs 811784 396 811388 1% /run
    tmpfs 2029460 0 2029460 0% /dev/shm
    tmpfs 5120 0 5120 0% /run/lock
    tmpfs 2029460 0 2029460 0% /sys/fs/cgroup
    /dev/sdb 103081248 85193336 12628648 88% /scsi1
    tmpfs 405892 0 405892 0% /run/user/0
    root@gauss:~#
< Backup MySQL | Backup Script | SSH >
Messages:
0 secs.