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

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

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

  @𝓒𝓱𝓻𝓲𝓼
  

  How to manage Buckups on a shared host ?
  How do you backup the DB ?

  
  
  Using a self-made shell script.

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

  @𝓒𝓱𝓻𝓲𝓼 Using PHPMyAdmin here. Easy.

  original

  • 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

        • -> View More Comments