Manage Website Databases
Managed Databases belong to exactly one Website Environment. They are available for hosted WordPress, PHP, and Node.js Websites. Static HTML and externally hosted Websites cannot create them.
Open Website → Databases. TMXIO selects the production environment by default and shows its current databases and logical restore points.
Create a database
Section titled “Create a database”- Select Create database.
- Enter a display name and stable slug.
- Choose MySQL or PostgreSQL.
- Enter the environment variable name the application expects, such as
DATABASE_URL. - Keep daily logical backups enabled unless the data is disposable.
- Select Provision database and wait for Ready.
TMXIO creates a unique database and user, generates the password, and injects one connection URL into the selected Website Environment. The password is never displayed in the dashboard.
Connect and maintain
Section titled “Connect and maintain”- Select Console to open a short-lived, single-database session. MySQL uses phpMyAdmin and PostgreSQL uses Adminer.
- Select Back up to request a logical restore point.
- Select Rotate to generate new credentials. The application must reconnect after the node applies them.
- Select Restore beside a completed backup to replace the current database contents.
Follow every operation until it reaches a terminal status. A queued or running status is not completion.
Download a saved backup
Section titled “Download a saved backup”Organization owners and admins can select Download latest backup beside a database. The timestamp identifies the saved backup; downloading does not create a fresh backup. To choose an older restore point, select Download beside a completed backup under Logical backups.
Downloads contain compressed SQL (.sql.gz) for MySQL or PostgreSQL. The filename includes the database name, engine, and backup timestamp. No saved backup means the button is disabled. Expired or missing backup files cannot be downloaded; choose another available backup. Retained backups can still be downloaded after their database is deleted, until retention expires.
Delete a database
Section titled “Delete a database”Select Delete, then type the database display name exactly. TMXIO blocks deletion while a backup or restore is active, then removes the database only after the hosting node confirms that both the login and database are gone. Existing retained backups remain available until their normal expiry; create an on-demand backup first when you need a fresh recovery point.
Deleting a Website Environment also deletes its Managed Databases. A database cannot be shared with another environment.