Google Drive Backups

blackeagles

When backing up databases, I get an error due to the api usage limit because it uploads each database to Google Drive separately.
e.g.

|-Uploading to Google Drive, please wait...
Traceback (most recent call last):
  File &quot;/www/server/panel/script/backup.py&quot;, line 59, in &lt;module&gt;
    backup.backupDatabaseAll(sys.argv[3], echo_id)
  File &quot;/www/server/panel/script/backup.py&quot;, line 37, in backupDatabaseAll
    self.backup_database_all(save, echo_id=echo_id)
  File &quot;/www/server/panel/class_v2/panel_backup_v2.py&quot;, line 983, in backup_database_all
    status, backup_path = self.backup_database(db_name, save, echo_id=echo_id)
                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File &quot;/www/server/panel/class_v2/panel_backup_v2.py&quot;, line 1120, in backup_database
    if upload_method(backup_path, upload_path):
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File &quot;/www/server/panel/plugin/gdrive/gdrive_main.py&quot;, line 350, in upload_file
    file = drive_service.files().create(body=file_metadata, media_body=media, fields='id').execute()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File &quot;/www/server/panel/pyenv/lib/python3.12/site-packages/oauth2client/_helpers.py&quot;, line 133, in positional_wrapper
    return wrapped(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File &quot;/www/server/panel/pyenv/lib/python3.12/site-packages/googleapiclient/http.py&quot;, line 810, in execute
    _, body = self.next_chunk(http=http, num_retries=num_retries)
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File &quot;/www/server/panel/pyenv/lib/python3.12/site-packages/oauth2client/_helpers.py&quot;, line 133, in positional_wrapper
    return wrapped(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File &quot;/www/server/panel/pyenv/lib/python3.12/site-packages/googleapiclient/http.py&quot;, line 977, in next_chunk
    return self._process_response(resp, content)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File &quot;/www/server/panel/pyenv/lib/python3.12/site-packages/googleapiclient/http.py&quot;, line 1008, in _process_response
    raise HttpError(resp, content, uri=self.uri)
googleapiclient.errors.HttpError: &lt;HttpError 403 when requesting https://www.googleapis.com/upload/drive/v3/files?fields=id&amp;alt=json&amp;uploadType=resumable returned &quot;Quota exceeded for quota metric 'Queries' and limit 'Queries per minute' of service 'drive.googleapis.com' for consumer 'project_number:226011xxx'.&quot;&gt;

But when backing up mails, all mails are uploaded as a single archive file. As I expected, there is no problem.
e.g.

|-Directory has been backed up to: /www/backup/path/vmail/path_vmail_20250523_053002_N9YrvZ.tar.gz
|-Uploading to Google Drive, please wait...
Upload Success ,File ID: ----
|-Successfully uploaded to Google Drive
==========================================================================================
☆backup is complete[2025-05-23 05:39:30]

I guess uploading the databases as a single archive would be a better solution.

Regards.

aaPanel_Kern

Hello,
What is the panel version? It may be a limitation caused by uploading to Google Drive at the same time
How many websites or databases do you have? Is it all backed up?

blackeagles

Hello,
panel version is 7.0.20. I have 20 databases. Since all backups are not always uploaded to Google Drive, I also make mandatory local backups. Yes, the problem is due to a limitation caused by uploading to Google Drive at the same time. Because each database is uploaded separately. Instead of this, I think it might be more logical to compress them all and upload a single file like in mails, because each mail domain is not uploaded individually.

Still, it's just a suggestion, I appreciate what you're doing. It's already a great panel!