Messages

1

Backup / Re: Dump the database 0 bytes after changing the IP server

« on: October 14, 2019, 01:38:32 PM »

Hello,
I managed to solve with the tip in this forum post.

https://forum.centos-webpanel.com/backup/server-never-make-mysql-backup/

2

Backup / Re: Dump the database 0 bytes after changing the IP server

« on: October 14, 2019, 01:06:44 PM »

Hello,
Did you find a solution?
I have the same problem my backups the Dbs are with 0 bytes

Hi.
After changing the IP server, the backup of the database stopped working correctly. All database dumps are 0 bytes in size. The user account is logged in the second time. It can be fixed?

3

Backup / Re: Restore of a full backup from the user portal not working

« on: July 10, 2019, 04:54:00 PM »

Hello,

Anything new you can do?
I need to restore a Full backup generated in CWP too and I do not find out how.

4

Backup / Re: Command line for restore full backup

« on: July 10, 2019, 04:53:21 PM »

I had created a full backup on user cwp control panel, and I transferred the backup file over to the new server which having the cwp installed.
The user account also being created on new cwp, but how am I going to restore the full backup by using console command line?

Hello,

Anything new you can do?
I need to restore a Full backup generated in CWP too and I do not find out how.

5

Backup / Re: Is there any way to make remote backup to google drive ?

« on: July 03, 2019, 03:01:51 PM »

Hi,

Currently I do not have en copy of CWPanel installed, although I am running a control panel which is based on above script and should work with CWP aswell.

Did you install the gdrive module?

Code: [Select]

#!/bin/bash
#
# The function uploads the backup directory
# to Google Drive in tar.gz format

# Copy the Drive folder ID where you'll upload your files (the after the https://drive.google.com/.../folders/...).
DRIVEFOLDERID=''

# Days in which to delete the old backups from google drive (set 0 to disable).
DELETEDAYS=30

# PASSWORD FOR ENCRYPTION (leave blank 2 disable)
PASSWORD=''

  echo "================================"
  gdrive about

  DATE=$(date '+%d-%m-%Y')
  TS=$(date +'%H%M%S')

  BAKFILE=/tmp/$HOSTNAME.$DATE.$TS.backup.tar.gz
  ENC_FILE=/tmp/$HOSTNAME.$DATE.$TS.backup.tar.gz.gpg
  tar -czvf "$BAKFILE" -C / backup > /dev/null

  if [ "$password" != '' ] ; then
    gpg -c --batch --yes --passphrase "$PASSWORD" "$BAKFILE"
  fi
 
  if [ -e "$BAKFILE" ] ; then
   if [ "$DELETEDAYS" > 0 ]; then
   upTime=$(date --date="$DELETEDAYS days ago" '+%Y-%m-%dT%T')
   gdrive list -q "name contains 'backup.tar.gz' and name contains '$HOSTNAME' and modifiedTime < '$upTime'" >> drive.txt
   filename='drive.txt'
   # Read the list file
   while read -r line
  do
   theId=$(cut -c-2 <<< "$line")
   #basically skip the first line...
   if [ "$theId" != "Id" ]; then
        echo "Deleting old backup file: "
gdrive delete $(cut -d ' ' -f1 <<< "$line")
   fi
   done < $filename
   # Remove temp list file
    rm -rf drive.txt
   fi

  if [ "$password" != '' ] ; then
    gdrive upload -p "$DRIVEFOLDERID" --delete "$ENC_FILE"
  else
    gdrive upload -p "$DRIVEFOLDERID" --delete "$BAKFILE"
  fi
 
  # ensures removal of backup file from /tmp
  rm -rf "$BAKFILE"

  if [ "$password" != '' ] ; then
    rm -rf "$ENC_FILE"
  fi
 
  echo "Google Drive backup complete ..."
  echo "--------------------------------"
 fi

exit 0
Daz

Hello people.
Thanks for all the help and attention.
I found my error was that I did not fill the field DRIVEFOLDERID =
After filling properly it worked perfect.
Thank you for sharing your scritp.

6

Backup / Re: Is there any way to make remote backup to google drive ?

« on: July 01, 2019, 09:52:16 PM »

This is based on a script I use for another Control Panel.

What this script does is backup everything in "/backup" folder (admin backups), and upload it to google drive in tar.gz format, this script will run after the CWP admin backup script has ran.

To use; get the gdrive binary for your OS (https://github.com/gdrive-org/gdrive#downloads).

Centos 6/7 64bit:

Code: [Select]

wget https://drive.google.com/uc?id=1Ej8VgsW5RgK66Btb9p74tSdHMH3p4UNb&export=download
Centos 6 32-bit

Code: [Select]

wget https://drive.google.com/uc?id=1eo9hMXz0WyuBwRxPM0LrTtQmhTgOLUlg&export=download
Make it executable:

Code: [Select]

chmod +x gdrive
Move it to /usr/sbin

Code: [Select]

mv gdrive /usr/sbin/
Setup:

Code: [Select]

gdrive about
Follow the link and get the verification code by authenticating with the google account for the drive you want access to.

Add the script into /root directory named: GDbackup.sh:

Code: [Select]

nano /root/GDbackup.sh
Copy  and paste the below script into the new file using (CTRL C / CTRL V).

And then save the file:

Code: [Select]

CTRL + X + Y
Script:

Code: [Select]

#!/bin/bash
IFS=$'\n'

# Copy the folder you want to store your file in at Google Drive (eg. https://drive.google.com/.../folders/...).
DRIVEFOLDERID=

# Days in which to delete the old backups from google drive (set 0 to disable).
DELETEDAYS=180


  echo "#############################################"
  echo "   ---Google Drive Backup---          "
  echo "#############################################"
  gdrive about
  echo "#############################################"

  DATE=$(date '+%d-%m-%Y')
  TS=$(date +'%H%M%S')
  tar -czvf /tmp/$HOSTNAME.$DATE.$TS.backup.tar.gz -C / backup > /dev/null
  BAKFILE=/tmp/$HOSTNAME.$DATE.$TS.backup.tar.gz

  if [ -e "$BAKFILE" ] ; then
   if [ "$DELETEDAYS" > 0 ]; then
   upTime=$(date --date="$DELETEDAYS days ago" '+%Y-%m-%dT%T')
   gdrive list -q "name contains 'backup.tar.gz' and name contains '$HOSTNAME' and modifiedTime < '$upTime'" >> drive.txt
   filename='drive.txt'
   # Read the list file
   while read -r line
  do
   theId=$(cut -c-2 <<< "$line")
   #basically skip the first line...
   if [ "$theId" != "Id" ]; then
        echo "Deleting old backup file: "
gdrive delete $(cut -c-33 <<< "$line")
   fi
done < $filename
# Remove temp list file
rm -rf drive.txt
fi


  gdrive upload -p "$DRIVEFOLDERID" --delete "$BAKFILE"
  # ensures removal of backup file from /tmp
  rm -rf "$BAKFILE"
 
  echo "Backup to Google Drive is complete..."
  echo "#############################################"
 fi

exit 0

Run this command to activate the automated cron job:

Code: [Select]

echo 'sh /root/GDbackup.sh' >> /etc/cron.daily/cwp
You will see the backup information in the email that CWP sends when the backup cron has ran, you can also run the script manually:

Code: [Select]

sh /root/GDbackup.sh
and enjoy your free space...! Hope this helps others..

Hello,
Thank you for your nomination.
Here when you try to run the script this error is reported.

Failed to get file: googleapi: Error 400: Invalid field selection appProperties, invalidParameter

with someone else, did the same thing happen?