Scheduled backup is not created for a particular domain

Created:

2016-11-16 13:16:24 UTC

Modified:

2017-08-08 13:38:15 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Scheduled backup is not created for a particular domain

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 12.0 for Linux

Symptoms

Scheduled backup is not created for a particular domain.

Cause

Database inconsistency.

Resolution

  1. Create a backup of Plesk database:

    # plesk db dump > psa.sql
  2. Use the affected domain's name to find a scheduled backup task in psa database:

    # plesk db "SELECT b.obj_id,d.name,b.obj_type,b.last,b.active,b.backup_time FROM BackupsScheduled b LEFT JOIN domains d ON b.obj_id=d.id where d.name='example.com'"
    +--------+-------------+----------+---------------------+--------+-------------+
    | obj_id | name | obj_type | last | active | backup_time |
    +--------+-------------+----------+---------------------+--------+-------------+
    | 8 | example.com | domain | 0000-00-00 00:00:00 | true | 02:30:00 |
    +--------+-------------+----------+---------------------+--------+-------------+
  3. Replace the incorrect record 0000-00-00 00:00:00 with any date in the past.

    # plesk db
    # mysql> update BackupsScheduled set last="2016-01-01 20:30:00" where obj_id=8;
  4. Reschedule the backup task at Domains > example.com > Backup Manager > Schedule

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