How to list all backup tasks setup on a domain level?

Created:

2016-12-18 06:55:00 UTC

Modified:

2017-08-24 03:46:27 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to list all backup tasks setup on a domain level?

Applicable to:

  • Plesk 12.5 for Linux

Question

How to list all backup tasks setup on a domain level in order to check what backups were scheduled by customers (domain owners)?

Answer

Run the following command:

mysql> select name, obj_id, obj_type, last, period, active, backup_time from BackupsScheduled,domains where obj_type='domain' and obj_id=domains.id";
+-----------------+--------+----------+---------------------+---------+--------+-------------+
| name | obj_id | obj_type | last | period | active | backup_time |
+-----------------+--------+----------+---------------------+---------+--------+-------------+
| example.com | 1 | domain | 2016-11-24 14:53:51 | 86400 | true | 14:00:00 |
| example2.com | 2 | domain | 2016-11-24 14:59:12 | 2592000 | true | 04:30:00 |
+-----------------+--------+----------+---------------------+---------+--------+-------------+

Where:

obj_type is indication that backup task was scheduled on a domain level. Otherwise it would have been "server"

last is the time when the backup task was run last time

period is the time frame between the last backup task and the next (in seconds). 86400 means that backup will be run once a day (once in 24 hours).

backup_time is the time when the backup should be started

Backups for suspended domains are not performed, even if active field for the backup task is set to true .

Additional information

#213946545 How Scheduled backup work? Scheduled backup is not created in requested time

Have more questions? Submit a request
Please sign in to leave a comment.