Changes between Version 8 and Version 9 of DbPurge

Timestamp:

Nov 2, 2009, 8:01:41 AM (15 years ago)

Author:

tonig

Comment:

small clarifications to the restore section

DbPurge

@@ -130 +130 @@
 
 
-== Restoring  archived results into the DB ==
+== Restoring archived results into the DB ==
 
 To extract old statistics, one has to recover the xml archive files (records  get periodically removed from the ''results'' table  by '''db_purge''').  This section explains a quick hack to recover the xml archive into a database. For now, only the '''result_archive''' is recreated, without xml data.
@@ -148 +148 @@
 #!/bin/sh
 
-# iterate over all arguments in the command line, filter them through
-# a fixup, feed them to mysql for import
+# iterate over all arguments in the command line, unzip them,
+# strip XML-in-XML and feed them to mysql for import
 
 tmpf=/tmp/boinc_import.$$
@@ -156 +156 @@
     echo Processing $f ...
 
-    # We need to remove the xml text
+    # Remove the 3 xml snippets of each result. Treat the file as a huge string.
     zcat -f $f | perl -w -e '
         use strict;
@@ -191 +191 @@
  3. At the end of the run, a  '''result_archive''' table will be reconstructed on the server. To add the most recent results, contained in the '''result''' table,  do (it will also take a while)
 {{{            
-INSERT INTO res SELECT * FROM result;
+INSERT INTO result_archive SELECT * FROM result;
 }}}