database-maintenance

Prerequisites

• PHP
• MySQL or MariaDB

Setup Instructions

1. Save Database Credentials

Create a file /config/db.ini and enter your database credentials in the following format:

hostname=your_hostname
databasename=your_databasename
username=your_username
password=your_password

2. Create Database Tables

Import all SQL files from the database directory into your database:

mysql -u your_username -p your_databasename < /path/to/database/file.sql

3. Transfer Files

Transfer all files to your server.

4. Maintain the database

Schedule maintainDatabase.php in order to find and repair table corruption, update index statistics, and reduce index and data fragmentation.