Manually editing your SQLite database with PHPLiteAdmin
15 December 2017 | 653 views
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. Alternatively, DB Browser for SQLite is ah excellent desktop application, so long as you don't mind downloading your database and working with it locally.
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.