This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
how_to:handling_database_backups [2013/09/20 09:01] – [Storing backups across the network] paul | how_to:handling_database_backups [2016/06/14 09:31] – [Storing backups across the network] paul | ||
---|---|---|---|
Line 3: | Line 3: | ||
By default, every day VPOP3 will backup the database to the VPOP3 installation directory as a file called ' | By default, every day VPOP3 will backup the database to the VPOP3 installation directory as a file called ' | ||
+ | |||
+ | =====Changing the backup filenames===== | ||
+ | To change the automatic database backup filename, go to the VPOP3 settings, then **Settings -> Database -> Backups**. | ||
+ | |||
+ | The '' | ||
+ | |||
+ | =====Changing the backup rotation cycle===== | ||
+ | The default automatic database backup which VPOP3 performs cycles backup files on a weekly basis. This is performed by saving the backup as a file DBBack-0.dmp on Sunday, DBBack-1.dmp on Monday, etc. The following Sunday, the previous DBBack-0.dmp file is overwritten meaning you have a week's worth of backups available. | ||
+ | |||
+ | This rotation is achieved by using ' | ||
+ | |||
+ | You could have a monthly rotation cycle, by using **%d** instead of **%w**. In this case, the backup filename would have the day of month appended, instead of the day of week. | ||
+ | |||
+ | In VPOP3 v6.1 and later, you can also set a specific rotation cycle by using %2, %3 up to %9 to set a 2, 3 to 9 day rotation, etc. | ||
+ | |||
+ | Some examples | ||
+ | * DBBACK.DMP - no rotation, each day's backup overwrites the previous day's backup | ||
+ | * DBBACK-%5.DMP - VPOP3 creates 5 backup files called DBBACK-0.DMP to DBBACK-4.DMP, | ||
+ | * DBBACK-%d-%h.DMP - VPOP3 creates backups with the day of month and hour (24hr) in the name. This can be useful if you do several backups a day and want to keep a lot of old backups | ||
+ | * DBBACK-%h.DMP - VPOP3 creates a backup with the hour in the name. This can be useful if you do several backups a day, but want VPOP3 to only keep backups from the last 24 hours. | ||
=====Storing Database backups elsewhere===== | =====Storing Database backups elsewhere===== | ||
Line 26: | Line 46: | ||
Also, because VPOP3 is running as a service, it needs to have permission to access the shared folder. In VPOP3 v6.1 and later you can specify the share account details in the Database -> Backup settings. In earlier versions of VPOP3 you can set VPOP3 to run as a different account which has share permissions (check ALL file permissions in that case), or you could set the sharing permissions to allow the whole VPOP3 computer access to the shares. | Also, because VPOP3 is running as a service, it needs to have permission to access the shared folder. In VPOP3 v6.1 and later you can specify the share account details in the Database -> Backup settings. In earlier versions of VPOP3 you can set VPOP3 to run as a different account which has share permissions (check ALL file permissions in that case), or you could set the sharing permissions to allow the whole VPOP3 computer access to the shares. | ||
+ | =keywords= | ||
+ | managing backups |