Wordpress create an array for wordpress installed

Hello

I have this script that backup the wordpress to google drive

---

Code:

#path to WordPress installations
SITESTORE="/nginx/domains"

#date prefix
DATEFORM=$(date +"%Y-%m-%d")

#Days to retain
DAYSKEEP=7

#calculate days as filename prefix
DAYSKEPT=$(date +"%Y-%m-%d" -d "-$DAYSKEEP days")

#create array of sites based on folder names
SITELIST=($(ls -lh $SITESTORE | awk '{print $9}'))

THE PROBLEM in the SITESTORE="/nginx/domains"

the script catches the underlying domains and backup them perfectly
but because the wordpress public folder lies below the domain folder WP-CLI dosnt understand it is a wordpress so it dosnt backup its SQL

how to solve this please?

 

Code:

 #back up the WordPress folder
    tar -czf $BACKUPPATH/$s/$DATEFORM-$s.tar.gz .
    #back up the WordPress database, compress and clean up
    wp db export $BACKUPPATH/$s/$DATEFORM-$s.sql --allow-root --skip-themes --skip-plugins
    cat $BACKUPPATH/$s/$DATEFORM-$s.sql | gzip > $BACKUPPATH/$s/$DATEFORM-$s.sql.gz
    rm $BACKUPPATH/$s/$DATEFORM-$s.sql

looks like I have a typo in this block, can u help please

 

looks like I'm missing /public will check now

 

it worked just fine,

do I need to fix permission?

Code:

#Fix permissions
sudo chown -R www-data:www-data $SITESTORE
sudo find $SITESTORE -type f -exec chmod 644 {} +
sudo find $SITESTORE -type d -exec chmod 755 {} +

 

thanks, it worked

 

hello again

I'm adapting this script

Code:

#!/usr/bin/env bash
# Source: https://guides.wp-bullet.com
# Author: Mike

#define local path for backups
BACKUPPATH="/tmp/backups"

#define remote backup path
BACKUPPATHREM="WP Bullet Backups"

#path to WordPress installations
SITESTORE="/var/www"

#date prefix
DATEFORM=$(date +"%Y-%m-%d")

#Days to retain
DAYSKEEP=7

#calculate days as filename prefix
DAYSKEPT=$(date +"%Y-%m-%d" -d "-$DAYSKEEP days")

#create array of sites based on folder names
SITELIST=($(ls -lh $SITESTORE | awk '{print $9}'))

#make sure the backup folder exists
mkdir -p $BACKUPPATH

#check remote backup folder exists on gdrive
BACKUPSID=$(gdrive list --no-header | grep $BACKUPPATHREM | grep dir | awk '{ print $1}')
   if [ -z "$BACKUPSID" ]; then
       gdrive mkdir $BACKUPPATHREM
       BACKUPSID=$(gdrive list --no-header | grep $BACKUPPATHREM | grep dir | awk '{ print $1}')
   fi

#start the loop
for SITE in ${SITELIST[@]}; do
   #delete old backup, get folder id and delete if exists
   OLDBACKUP=$(gdrive list --no-header | grep $DAYSKEPT-$SITE | grep dir | awk '{ print $1}')
   if [ ! -z "$OLDBACKUP" ]; then
       gdrive delete $OLDBACKUP
   fi

   # create the local backup folder if it doesn't exist
   if [ ! -e $BACKUPPATH/$SITE ]; then
       mkdir $BACKUPPATH/$SITE
   fi

   #entire the WordPress folder
   cd $SITESTORE/$SITE
 
   #back up the WordPress folder
   tar -czf $BACKUPPATH/$SITENAME/$SITE/$DATEFORM-$SITE.tar.gz .
   #back up the WordPress database, compress and clean up
   wp db export $BACKUPPATH/$SITE/$DATEFORM-$SITE.sql --allow-root --skip-themes --skip-plugins
   cat $BACKUPPATH/$SITE/$DATEFORM-$SITE.sql | gzip > $BACKUPPATH/$SITE/$DATEFORM-$SITE.sql.gz
   rm $BACKUPPATH/$SITE/$DATEFORM-$SITE.sql
 
   #get current folder ID
   SITEFOLDERID=$(gdrive list --no-header | grep $SITE | grep dir | awk '{ print $1}')

   #create folder if doesn't exist
   if [ -z "$SITEFOLDERID" ]; then
       gdrive mkdir --parent $BACKUPSID $SITE
       SITEFOLDERID=$(gdrive list --no-header | grep $SITE | grep dir | awk '{ print $1}')
   fi

   #upload WordPress tar
   gdrive upload --parent $SITEFOLDERID --delete $BACKUPPATH/$SITE/$DATEFORM-$SITE.tar.gz
   #upload wordpress database
   gdrive upload --parent $SITEFOLDERID --delete $BACKUPPATH/$SITE/$DATEFORM-$SITE.sql.gz

done

to centminmod

Code:

#!/usr/bin/env bash


#define local path for backups
BACKUPPATH="/tmp/backups"

#define remote backup path
BACKUPPATHREM="wp-gce-backups"

#path to WordPress installations
SITESTORE="/home/nginx/domains"

#date prefix
DATEFORM=$(date +"%Y-%m-%d")

#Days to retain
DAYSKEEP=7

#calculate days as filename prefix
DAYSKEPT=$(date +"%Y-%m-%d" -d "-$DAYSKEEP days")

#create array of sites based on folder names
SITELIST=$(ls $SITESTORE)
for s in ${SITELIST[0]}; do echo -n "backup $s: "; echo "/home/nginx/${s}/public";done

#SITELIST=($(ls -lh $SITESTORE | awk '{print $9}'))

#make sure the backup folder exists
mkdir -p $BACKUPPATH

#check remote backup folder exists on gdrive
BACKUPSID=$(gdrive list --no-header | grep $BACKUPPATHREM | grep dir | awk '{ print $1}')
    if [ -z "$BACKUPSID" ]; then
        gdrive mkdir $BACKUPPATHREM
        BACKUPSID=$(gdrive list --no-header | grep $BACKUPPATHREM | grep dir | awk '{ print $1}')
    fi

#start the loop
for s in ${SITELIST[@]}; do
    #delete old backup, get folder id and delete if exists
    OLDBACKUP=$(gdrive list --no-header | grep $DAYSKEPT-$s | grep dir | awk '{ print $1}')
    if [ ! -z "$OLDBACKUP" ]; then
        gdrive delete $OLDBACKUP
    fi

    # create the local backup folder if it doesn't exist
    if [ ! -e $BACKUPPATH/$s ]; then
        mkdir $BACKUPPATH/$s
    fi

    #entire the WordPress folder
    cd $SITESTORE/$s/public
 
    #back up the WordPress folder
    tar -czf $BACKUPPATH/$s/$DATEFORM-$s.tar.gz .
    #back up the WordPress database, compress and clean up
    wp db export $BACKUPPATH/$s/$DATEFORM-$s.sql --allow-root --skip-themes --skip-plugins
    cat $BACKUPPATH/$s/$DATEFORM-$s.sql | gzip > $BACKUPPATH/$s/$DATEFORM-$s.sql.gz
    rm $BACKUPPATH/$s/$DATEFORM-$s.sql
 
    #get current folder ID
    SITEFOLDERID=$(gdrive list --no-header | grep $s | grep dir | awk '{ print $1}')

    #create folder if doesn't exist
    if [ -z "$SITEFOLDERID" ]; then
        gdrive mkdir --parent $BACKUPSID $s
        SITEFOLDERID=$(gdrive list --no-header | grep $s | grep dir | awk '{ print $1}')
    fi

    #upload WordPress tar
    gdrive upload --parent $SITEFOLDERID --delete $BACKUPPATH/$s/$DATEFORM-$s.tar.gz
    #upload wordpress database
    gdrive upload --parent $SITEFOLDERID --delete $BACKUPPATH/$s/$DATEFORM-$s.sql.gz

done
[/CDOE]

I managed to get it done with the help of @eva above

however, I'm getting errors: mailnly to delete the old backups

[CODE]
Success: Exported to '/tmp/backups/DOMAIN.COM/2017-04-15-DOMAIN.COM.sql'.

No valid arguments given, use 'gdrive help' to see available commands

Failed to get file: googleapi: Error 404: File not found: --delete., notFound

Failed to get file: googleapi: Error 404: File not found: --delete., notFound

-also sometimes the WP-CLI dB backup is not complete when running clone

Dropbox - Screenshot 2017-04-15 13.09.09.png


please help

 

I made many improvement on the script, it backs up fine when run manually

but backs up the db with 20 Byte size when run from the cron, very weird

 

The script is above, but the WP-CLI DB export dosnt work in cron