Database Access
Many apps we offer need a database to keep settings and user data. PikaPods provides a local database to each pod that needs it. This gives the best speed, while still allowing us to take daily backups for you.
Edit the Pod’s Database
Section titled “Edit the Pod’s Database”Advanced users can directly access the database of certain apps to make small edits or import/export data.
Enabling Database Access
- Navigate to Pod Settings > Database.
- You will find an “Enable Database Access” switch. Toggle it to enable or disable database access, depending on your needs.
- Enabling it will display a login link and a password. The link opens Adminer, a web-based tool to browse and edit the database.
This feature may not be available for all apps. Some apps use SQLite databases, which can be accessed using SFTP to retrieve the database file.
Security Considerations
For improved security, it’s essential to keep the database access feature disabled when you’re not actively using it. This helps protect your data and minimize potential security risks.
Import and Export the Pod’s Database
Section titled “Import and Export the Pod’s Database”After enabling database access, you can use the import and export features of Adminer to replace the whole database, if needed. Be sure the pod is stopped when doing this.