Database Management
Provision, access, and back up your databases.
Creating a Database
Go to your server's Databases tab and click Create Database. Choose the database type and version, enter a name and password, and Depnix will provision it in seconds. See the Supported Databases page for available types and versions.
Database Credentials
After creation, find the host, port, database name, username, and password in the database detail page. These can be copied directly into your application's environment variables.
Use 127.0.0.1 as the host when your application and database are on the same server.
Connecting from Your Application
Set the database credentials as environment variables in your application (e.g. DB_HOST, DB_PORT, DB_DATABASE, DB_USERNAME, DB_PASSWORD). Most frameworks pick these up automatically from the environment.
Database Backups
Enable automated backups from the database settings to take daily snapshots. Backups are compressed and stored on the server. You can also trigger a manual backup at any time before making schema changes.
Restoring a Backup
Open the Backups tab for your database, select the snapshot you want to restore, and click Restore. The restore process replaces the current database contents with the snapshot. Existing data will be overwritten.
Always take a fresh manual backup before restoring to avoid losing recent data.
Remote Access
Remote database connections are disabled by default for security. To connect from your local machine, use an SSH tunnel: ssh -L 3306:127.0.0.1:3306 user@your-server-ip, then connect to localhost:3306.