Changes between Version 8 and Version 9 of DbPurge


Ignore:
Timestamp:
Nov 2, 2009, 8:01:41 AM (15 years ago)
Author:
tonig
Comment:

small clarifications to the restore section

Legend:

Unmodified
Added
Removed
Modified
  • DbPurge

    v8 v9  
    130130
    131131
    132 == Restoring  archived results into the DB ==
     132== Restoring archived results into the DB ==
    133133
    134134To 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.
     
    148148#!/bin/sh
    149149
    150 # iterate over all arguments in the command line, filter them through
    151 # a fixup, feed them to mysql for import
     150# iterate over all arguments in the command line, unzip them,
     151# strip XML-in-XML and feed them to mysql for import
    152152
    153153tmpf=/tmp/boinc_import.$$
     
    156156    echo Processing $f ...
    157157
    158     # We need to remove the xml text
     158    # Remove the 3 xml snippets of each result. Treat the file as a huge string.
    159159    zcat -f $f | perl -w -e '
    160160        use strict;
     
    191191 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)
    192192{{{           
    193 INSERT INTO res SELECT * FROM result;
     193INSERT INTO result_archive SELECT * FROM result;
    194194}}}
    195195