Difference between revisions of "Querying your own database"
From Charitylog Manual
| 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 | + | 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:
