# Optional variables for a backup script
MYSQL_USER="root"
MYSQL_PASS="root"
MYSQL_DATABASE_PREFIX="shopify_app_"
PROJECT_DIR="/var/www/html/dev"
BACKUP_DIR=$PROJECT_DIR"/storage/app/backup/"
test -d "$BACKUP_DIR" || mkdir -p "$BACKUP_DIR"
# Get the database list, exclude information_schema
cd $BACKUP_DIR
rm * -f
mysqldump -u $MYSQL_USER --password=$MYSQL_PASS "flits" | gzip > "$BACKUP_DIR/flits.sql.gz"
for db in $(mysql -B -s -u $MYSQL_USER --password=$MYSQL_PASS -e 'show databases like "shopify_app_%"')
do
  # dump each database in a separate file
  mysqldump -u $MYSQL_USER --password=$MYSQL_PASS "$db" | gzip > "$BACKUP_DIR/$db.sql.gz"
done
cd $BACKUP_DIR
tar -czvf backup.tar.gz *
rm *.sql.gz -f
cd $PROJECT_DIR
php artisan create:backup