Difference between revisions of "Querying your own database"
From Charitylog Manual
| Line 1: | Line 1: | ||
Your entire database can be downloaded in a single file. Please see [https://wiki.charitylog.co.uk/index.php?title=Backup_Data| How to backup your data]. | Your entire database can be downloaded in a single file. Please see [https://wiki.charitylog.co.uk/index.php?title=Backup_Data| How to backup your data]. | ||
| − | If you are familiar with administering databases, you may wish to rebuild the database | + | 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 | * Advanced reporting using SQL queries | ||
* 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. | ||
Revision as of 16:11, 24 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 a starter guide for understanding the underlying structure of the database.
