How can I change the scheduled backup start time for an Auto Backup?
OnApp Cloud 2.x/3.x
Currently, backups are scheduled to start at the time of day they were scheduled. To modify this, you need to alter the start_at field to the day and time that you would like the backup to queue next, in the schedules table. In this table, target_id is the disk # that is to be backed up, which the disk # can be found on the VM page in the UI, under "Storage".
As it is sometimes requested that these backups should all queue at the same time each day, here are some example MySQL queries to set the daily backups to queue at midnight, then weekly to 2am, and monthly backups to 4am:
update schedules set start_at = DATE(start_at) where period = "days"; update schedules set start_at = DATE_ADD( DATE(start_at), interval 2 hour) where period ="weeks"; update schedules set start_at = DATE_ADD( DATE( start_at), interval 4 hour) where period ="months";
Additional "where" clauses, such as 'where period= "days"' and 'target_id=23' may be used to narrow the scope as needed. Also, the date/time specified is always GMT.