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

jrp@hub.kliklak.net@hub.kliklak.net ⁨3⁩ ⁨weeks⁩ ago

• chris@im.allmendenetz.de ⁨3⁩ ⁨weeks⁩ ago

  @*_jߍyrope sure but looking for automated backup options

  original

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

    @𝓒𝓱𝓻𝓲𝓼 Saving the directory and associated SQL dump doesn't require an extra tool.
    
    

    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.* .
    }

    original

    • chris@im.allmendenetz.de ⁨3⁩ ⁨weeks⁩ ago

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

      original

      • abu@hub.alfredbuehler.ch ⁨3⁩ ⁨weeks⁩ 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

        • -> View More Comments