Manually editing your SQLite database with PHPLiteAdmin
15 December 2017 | 87 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).
A safer option is to download your database then edit it locally with DB Browser for SQLite, and then upload it again. Don't forget to backup a copy of the original before you start editing it!
Copyright, all rights reserved.