Comment on @Hubzilla Support Forum Mine is running on a shared host. I have SSH and Git a

abu@hub.alfredbuehler.ch ⁨1⁩ ⁨day⁩ ago

backup() {
    ssh -T $HOST << EOF
    tar -C $APPDIR_REMOTE -czf archive/$ARCHIVE.tar.gz
    mysqldump -h 127.0.0.1 $DBNAME > archive/$ARCHIVE.sql
    gzip -f archive/$ARCHIVE.sql
    find archive/ -type f -name "${PREFIX}*.gz" -mtime +$DAYS -delete
EOF
    scp $HOST:/archive/$ARCHIVE.* .
}

• chris@im.allmendenetz.de ⁨9⁩ ⁨hours⁩ ago

  @Alfred Bühler thanks
  
  But how to automat the creation oft the SQL dump ?

  original

  • abu@hub.alfredbuehler.ch ⁨3⁩ ⁨hours⁩ ago

    @𝓒𝓱𝓻𝓲𝓼
    

    But how to automat the creation oft the SQL dump ?

    
    
    ?? It's done by mysqldump from within the backup function. Automation can be done by using a cron job. Or do you refer to something else?

    original

    • chris@im.allmendenetz.de ⁨1⁩ ⁨hour⁩ ago

      How to set up such a cron job?

      original

      • abu@hub.alfredbuehler.ch ⁨1⁩ ⁨hour⁩ ago

        @𝓒𝓱𝓻𝓲𝓼 Write an appropriate shell script and add it to your crontab. Everyday admin jobs. I cannot explain it deeper in detail here.

        original