Opened 5 years ago

Closed 5 years ago

#2217 closed task (fixed)

No per day backup of OSGeo database

Reported by: cvvergara Owned by: robe
Priority: major Milestone:
Component: SysAdmin Keywords:
Cc:

Description

From the backup directory

ls -la osgeo_*
-rw-r--r-- 1 robe users   4350437 May 11 23:05 osgeo_180511.sql.gz
-rw-r--r-- 1 root root    3889728 Mar 25  2018 osgeo_2018030.sql.gz
-rw-r--r-- 1 root root    3889728 Mar 26  2018 osgeo_2018031.sql.gz
-rw-r--r-- 1 root root    3889728 Mar 27  2018 osgeo_2018032.sql.gz
-rw-r--r-- 1 root root    3889728 Mar 28  2018 osgeo_2018033.sql.gz
-rw-r--r-- 1 root root    3889728 Mar 29  2018 osgeo_2018034.sql.gz
-rw-r--r-- 1 root root    3889728 Mar 30  2018 osgeo_2018035.sql.gz
-rw-r--r-- 1 root root    3889728 Mar 31  2018 osgeo_2018036.sql.gz
-rw-r--r-- 1 root root    3889728 Apr  1  2018 osgeo_2018040.sql.gz
-rw-r--r-- 1 root root    4263575 Apr 23  2018 osgeo_2018041.sql.gz
-rw-r--r-- 1 root root    3889728 Apr  3  2018 osgeo_2018042.sql.gz
-rw-r--r-- 1 root root    3889728 Apr  4  2018 osgeo_2018043.sql.gz
-rw-r--r-- 1 root root    3889728 Apr  5  2018 osgeo_2018044.sql.gz
-rw-r--r-- 1 root root    3889728 Apr  6  2018 osgeo_2018045.sql.gz
-rw-r--r-- 1 root root    4172979 Apr  7  2018 osgeo_2018046.sql.gz
-rw-r--r-- 1 root root    4350637 May 11 23:23 osgeo_2018055.sql.gz
-rw-r--r-- 1 root root    4353463 May 12 17:00 osgeo_2018056.sql.gz
-rw-r--r-- 1 root root    4812075 Jul 30 17:00 osgeo_2018071.sql.gz
-rw-r--r-- 1 root root    4819277 Jul 31 17:00 osgeo_2018072.sql.gz
-rw-r--r-- 1 root root    4849352 Aug 12 17:00 osgeo_2018080.sql.gz
-rw-r--r-- 1 root root    4886267 Aug 16 17:00 osgeo_20180816_before_gravity_forms_upgrade.sql.gz
-rw-r--r-- 1 root root    4858240 Aug 13 17:00 osgeo_2018081.sql.gz
-rw-r--r-- 1 root root    4868315 Aug 14 17:00 osgeo_2018082.sql.gz
-rw-r--r-- 1 root root    4873122 Aug 15 17:00 osgeo_2018083.sql.gz
-rw-r--r-- 1 root root    4886283 Aug 17 17:00 osgeo_2018085.sql.gz
-rw-r--r-- 1 root root    4881750 Aug 11 17:00 osgeo_2018086.sql.gz
-rw-r--r-- 1 root root    5186822 Sep 26 17:07 osgeo_2018093.sql.gz
-rw-r--r-- 1 root root    5186822 Sep 27 17:00 osgeo_2018094.sql.gz
-rw-r--r-- 1 root root   26077219 Jun  9 00:16 osgeo_daily_180608.sql
-rw-r--r-- 1 root root  762652782 Aug 16 17:01 osgeo_wp_180816_before_gravity_forms_upgrade.tar.gz
-rw-r--r-- 1 root root  824041645 Nov  8 17:01 osgeo_wp_daily.tar.gz

Looks like its not backing per day

I guess this is the daily backup

-rw-r--r--  1 root     root     824041645 Nov  8 17:01 osgeo_wp_daily.tar.gz

Change History (5)

comment:1 by robe, 5 years ago

Owner: changed from sac@… to robe

I'll take a look at it later today

comment:2 by cvvergara, 5 years ago

osgeo_wp_daily.tar.gz is not the database backup

comment:3 by robe, 5 years ago

Correct that's the website backup. The database backups were set to rotate.

comment:4 by robe, 5 years ago

sorry was making backup in wrong place. I'll move them and the fix the script.

-rw-r--r--  1 0 0 178M Nov  8 17:00 foss4g2018_daily.sql
-rw-r--r--  1 0 0  85K Nov  8 17:00 grass_staging_daily.sql
-rw-r--r--  1 0 0  30M Nov  8 17:00 osgeo_daily.sql
-rw-r--r--  1 0 0  30M Nov  8 17:00 staging_osgeo_daily.sql
Last edited 5 years ago by robe (previous) (diff)

comment:5 by cvvergara, 5 years ago

Resolution: fixed
Status: newclosed

Thanks

Note: See TracTickets for help on using tickets.