Using the DB Admin Backend Interface
Part 1: Feature Overview
The dashboard is your command center. It provides an immediate high-level overview of your database health and statistics.
View total number of tables, total records across the database, and the physical size on disk.
Quickly access the top 5 largest or most recently accessed tables without searching.
One-click access to common tools like the SQL Console or Export wizard.
The Tables view lists all tables in your database and allows you to manage them.
- Sorting: Click column headers to sort tables by name, row count, size, engine, or collation.
- Search: Use the search bar at the top to filter the table list by name instantly.
- Actions:
- Browse: Opens the data view to see records.
- Structure: Opens the schema editor to modify columns and indices.
The core of DB Admin. View, filter, and manipulate your data with ease.
Advanced Filtering
Use the collapsible filter panel to search for specific records. You can combine multiple filters.
LIKE(Contains text)=(Exact match)>,<(Greater/Less than)IS NULL/IS NOT NULL
Editing & Actions
Manage records directly from the list:
- Edit: Click to modify a record.
- Delete: Click to remove a single record.
- Bulk Delete: Select multiple rows via checkboxes and use the "Delete Selected" button.
- Add: Use the green "New Record" button to insert data.
Modify the design of your tables without writing complex SQL statements.
CREATE TABLE statement. Useful for documentation, backups, or replicating the table structure on another server.
Import
Upload CSV files to populate tables. The intelligent wizard guides you through:
- Upload: Select file and set delimiter/charset.
- Mapping: Match CSV columns to database fields.
- Preview: Check data before importing.
Export
Download table data in various formats for backup or analysis:
SQL Console
Execute raw SQL queries directly against the database. Includes history and schema browser.
Procedures & Triggers
View definitions of Stored Procedures and Triggers to understand business logic.
Process Manager
View currently running queries. Kill processes that are stuck or slowing down the system.
Part 2: Common Admin Tasks
Finding Specific Data
Scenario: You need to find a user with the email "john.doe@example.com".
- Navigate to Tables and click the button next to the
userstable. - Click on the Filter & Search bar at the top to expand it.
- Select the field
emailfrom the first dropdown. - Choose the operator
LIKE(contains) or=(exact match). - Enter
john.doein the value field. - Click Apply Filter. The list will update to show only matching records.
Adding a New Field
Scenario: You need to add a "phone_number" field to the customers table.
- Go to Tables and click the button next to
customers. - Click the green Add Field button at the top right.
-
Fill out the modal form:
- Name:
phone_number - Type:
VARCHAR - Length:
20
- Name:
- Click Create. The column is added immediately to the database.
Importing Data from Excel
Scenario: You have a product list in Excel and want to import it into the database.
- Save your Excel file as CSV (Comma delimited) or CSV (UTF-8).
- In DB Admin, click Import in the sidebar.
- Select the target table (e.g.,
products) from the dropdown. - Upload your CSV file. Adjust the Delimiter (usually
;for European Excel or,for US) if necessary. - Click Analyze.
- Map the CSV columns to your database fields using the dropdowns. Select "Ignore" for columns you don't need.
- Click Execute Import.
Emergency: Stopping a Stuck Query
Scenario: The database is slow because of a heavy report running in the background.
- Navigate to Processes in the sidebar.
- Look for a process with a high Time value or a complex Info state.
- Click the red button next to that process.
- Confirm the action to terminate the query immediately.