Database Map Tool

This page explains the Database Map Tool in GoAdmio. It lets you assign ownership of existing MySQL/MariaDB databases and database users to a specific hosting account — without renaming or recreating them.

Location: Admin Panel → Databases → Database Map Tool

Overview

Every database in GoAdmio is normally created with a username prefix tied to the hosting account that created it (e.g., accountname_dbname). This prefix enforces ownership: the database appears in that account's MySQL Databases page, and the account can manage it.

Sometimes a database exists without a proper account mapping — for example:

A database was created manually via the CLI and has no GoAdmio record
A database was restored from a backup created on another server
A database was migrated from cPanel and its prefix does not match any local account
An account was renamed, or its databases were moved between accounts
A database owner needs to be changed without dropping and recreating the database

The Database Map Tool solves this by letting you map an existing database and its users to an account. Once mapped, the database appears in that account's MySQL Databases page, and the account owner can manage it as if it had been created there.

> Note: The Database Map Tool does not rename databases or users. It only creates the ownership mapping that GoAdmio uses to determine which account controls the database. The actual database name and username remain unchanged.

What the Page Shows

| Field / Column | Description |
|---|---|
| Account | The hosting account to which you want to assign ownership |
| Database | The existing database name (without the account prefix) |
| Database User | The existing database user to associate with the account |
| Type | The database type (MySQL/MariaDB) |
| Map | Apply the mapping |
| Status / Output | Result of the mapping operation |

> Tip: The Database and Database User fields accept the full existing name, not a prefixed version. The tool maps the existing resource to the account; it does not add a prefix.

When to Use the Database Map Tool

| Scenario | Use this tool? |
|---|---|
| A database was created via CLI and does not appear in any account | ✅ Yes — map it to the correct account |
| A database was restored from a backup and needs to be visible to an account | ✅ Yes |
| A database was migrated from cPanel and the prefix does not match a local account | ✅ Yes |
| You need to transfer database ownership from one account to another | ✅ Yes — map it to the new account |
| You want to rename a database | ❌ No — databases cannot be renamed; create a new one and migrate |
| You want to create a new database | ❌ No — use MySQL Databases |
| You want to delete a database | ❌ No — use MySQL Databases |

> Warning: Mapping a database to an account does not move the database files. The database remains in the same physical location on disk; only the ownership record changes. Make sure the account has sufficient privileges and that no other account is actively using the database.

How to Map a Database to an Account

Via the Admin Panel

Log in to the GoAdmio Admin Panel.
Navigate to Databases → Database Map Tool.
Select the Account you want to assign the database to.
Enter the Database name (the full existing name, e.g., legacy_wp).
Enter the Database User to associate (e.g., legacy_wpuser).
Select the Type (MySQL or MariaDB).
Click Map (or Assign).

The database and user are now associated with the selected account. The account owner can manage them from Databases → MySQL Databases in the User Panel.

Via CLI

GoAdmio provides a command-line equivalent for the Database Map Tool. The exact syntax depends on your version; see Command Reference. The general form is:

```bash
/go/dbmap <account> <database> <database_user> [type]