Manually editing your SQLite database with PHPLiteAdmin

15 December 2017 | 65 views | Tags: Documentation

Occasionally you may find it useful to be able to manually edit your database, for example to run custom queries, correct a site-wide spelling error or to add a Yubikey ID. I recommend that you try PHPLiteAdmin, which provides a web-based interface for interacting with your database. It’s similar to PHPMyAdmin. Download it and drop it into your /admin directory. Some minor configuration is necessary, but instructions are provided as comments in the script.

Ensure that you use a strong password when you are setting up the configuration file for PHPLiteAdmin. Actually, it is not a good idea to leave the script sitting around on your site. When not in use, move the script to your trust_path folder so that it can’t be accessed via browser, or keep it on your local machine and upload it when required (and remove it when done).

Copyright, all rights reserved.

Related

Tuskfish CMS User Manual

The user manual provides a comprehensive guide to Tuskfish CMS operations. It covers all all aspects from installation to adding and curating content, managing site security and customisation of themes. For additional information on how to customise Tuskfish please see the developer guide.