Difference between revisions of "Querying your own database"

From Charitylog Manual
Jump to: navigation, search
Line 5: Line 5:
 
* As an emergency backup, e.g. during outages at the data centre or network infrastructure.
 
* As an emergency backup, e.g. during outages at the data centre or network infrastructure.
  
This page provides a starter guide for understanding the underlying structure of the database.
+
This page provides some sample queries to help understand the underlying structure of the database.
 +
 
 +
'''A list of people'''
 +
The types of Organisations and People are stored in the organisations_types table. The orgs/people are stored in the organisations table. A list of active volunteers can be found using:

Revision as of 09:29, 25 June 2020

Your entire database can be downloaded in a single file. Please see How to backup your data.

If you are familiar with administering databases, you may wish to rebuild the database into a local MySQL or MariaDb server. This may be for:

  • Advanced reporting using SQL queries
  • As an emergency backup, e.g. during outages at the data centre or network infrastructure.

This page provides some sample queries to help understand the underlying structure of the database.

A list of people The types of Organisations and People are stored in the organisations_types table. The orgs/people are stored in the organisations table. A list of active volunteers can be found using: