Changes between Version 23 and Version 24 of DatabaseBasedAnalysis


Ignore:
Timestamp:
08/04/18 18:42:28 (6 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DatabaseBasedAnalysis

    v23 v24  
    33DatabaseBasedAnalysis/Connection
    44
    5 == rootifysql ==
    6 
    7 A convenient way to retrieve data is the ''rootifysql'' tool which is part of the FACT++ package. More details can be found either calling it with the --help option or at https://www.fact-project.org/logbook/showthread.php?tid=4192. The same access rules as if the native mysql client is used apply.
    8 
    9 To simplify the usage, it is wise to write a rootifysql.rc file with the following contents:
    10 
    11 {{{uri=fact:password@iph-pc45.ethz.ch/factdata}}}
    12 
    13 The following tutorial assumes that such a file exists.
    14 
    15 == Other alternatives ==
     5== Tools to access the database ==
     6
     7=== rootifysql ===
     8
     9A convenient way to retrieve data is the ''rootifysql'' tool which is part of the FACT++ package. As the name suggests, it writes the data into root files (but can also write the data into ascii files as the mysql-client). More details can be found either calling it with the --help option or at https://www.fact-project.org/logbook/showthread.php?tid=4192.
     10
     11=== Other alternatives ===
    1612
    1713Many possibilities exist to access a mysql database as a C API, MySQL++, Python (MySQL.Connector), PHP and others. You are free to use whatever tool you like. In the following, an analysis will be outlined using the ''rootifysql'' client and because it is most convenient.
    1814
    19 == PhpMyAdmin ==
    20 
    21 To get a fast glimpse on the accessible databases and tables, you can log-in to PhpMyAdmin at http://iph-pc45.ethz.ch/phpmyadmin 
     15=== PhpMyAdmin ===
     16
     17To get a fast glimpse on the accessible databases and tables, you can log-in to PhpMyAdmin at http://iph-pc45.ethz.ch/phpmyadmin
    2218
    2319= The Analyis =