Changes between Version 35 and Version 36 of DatabaseBackups

Timestamp:

Jun 6, 2014, 11:21:12 AM (12 years ago)

Author:

eugene

Comment:

--

DatabaseBackups

@@ -70 +70 @@
 
 It can be found (on the production cluster) in ~ipp/softwares and it is installed in ~ipp/local.
+
+== ipp001 dumps and log-spaced retention ==
+
+ipp001 is the destination for gpc1 and other mysql database dumps.  these start to fill the disk occasionally.  there is a script in the ipp user's home directory to remove all but a log-spaced set of copies (dayly for a week, weekly for a month, monthly for years).  to run this, log into ipp001 as the ipp user and follow the commands below:
+
+{{{
+cd /data/ipp001.0/ipp/mysql-dumps>
+~ipp/mysql-dump/delete_log_spacing.sh mysql-ssp-ipp001 test
+~ipp/mysql-dump/delete_log_spacing.sh mysql-ssp-ipp001 commit
+~ipp/mysql-dump/delete_log_spacing.sh mysql-isp-ipp001 test
+~ipp/mysql-dump/delete_log_spacing.sh mysql-isp-ipp001 commit
+~ipp/mysql-dump/delete_log_spacing.sh mysql-gpc1-ippdb03 test
+~ipp/mysql-dump/delete_log_spacing.sh mysql-gpc1-ippdb03 commit
+}}}
+
+