Changes between Version 1 and Version 2 of DbDump


Ignore:
Timestamp:
Oct 21, 2007, 4:54:54 AM (17 years ago)
Author:
Christian Beer
Comment:

explained this a bit more. Comment: We should make the archive_dir a default option for new projects (nobody likes cluttered up directories).

Legend:

Unmodified
Added
Removed
Modified

  • DbDump

    v1 v2  
    11= Exporting credit statistics with db_dump =
    22
    3 The program db_dump generates XML files containing your project's credit data. It should be run every 24 hours. Include an entry like
     3The program db_dump generates XML files containing your project's credit data. This data is used by 3rd-party sites to generate some charts and graphs. It should be run every 24 hours. Include an entry like
    44{{{
    55    <tasks>
    … …  
    1212}}}
    1313
    14 in your [ProjectTasks config.xml] file. Make sure the file db_dump_spec.xml is in your project's root directory.
     14in your [ProjectTasks config.xml] file. Make sure the file db_dump_spec.xml is in your project's root directory. This file should look like this:
     15{{{
     16    <boinc_db_dump_spec>
     17        <output_dir>../html/stats_tmp</output_dir>
     18        <final_output_dir>../html/stats</final_output_dir>
     19        <enumeration>
     20            <table>user</table>
     21            <filename>user</filename>
     22            <output>
     23                <compression>gzip</compression>
     24            </output>
     25        </enumeration>
     26        <enumeration>
     27            <table>host</table>
     28            <filename>host</filename>
     29            <output>
     30                <compression>gzip</compression>
     31                <detail/>
     32            </output>
     33        </enumeration>
     34        <enumeration>
     35            <table>team</table>
     36            <filename>team</filename>
     37            <output>
     38                <compression>gzip</compression>
     39            </output>
     40        </enumeration>
     41    </boinc_db_dump_spec>
     42}}}
    1543
    16 The XML files are written to html/stats/, and the old stats/ directory is renamed to stats_DATE. This clutters up your html/ directory; if you don't like this, create a directory html/stats_archive/ and add the line
     44The XML files are written to ''<final_output_dir>'', and the old stats/ directory is renamed to stats_DATE. This clutters up your html/ directory; if you don't like this, create a directory html/stats_archive/ and add the line
    1745{{{
    1846<archive_dir>../html/stats_archive</archive_dir>
    1947}}}
    20 to your db_dump_spec.xml file.
     48to your db_dump_spec.xml file. If you've set up [ServerIntro#permissions groups and permissions] correct you need a 755 permission on the stats directories only.