How to Use phpMyAdmin for Advanced Database Management

phpMyAdmin is a web-based database management tool included with every dotCanada cPanel account. It gives you a graphical interface to manage your MySQL databases, run SQL queries, import and export data, and modify table structures.

Accessing phpMyAdmin

Log in to cPanel.
Go to Databases > phpMyAdmin.
Select the database you want to work with from the left-hand sidebar.

Common Tasks

Running SQL Queries

Click the SQL tab at the top to open a query editor. You can run any valid SQL statement, such as:

SELECT * FROM wp_users WHERE user_login = 'admin';

Importing a Database

Select your database in the sidebar.
Click the Import tab.
Choose your .sql file and click Go.

Exporting a Database

Select your database in the sidebar.
Click the Export tab.
Choose Quick export and SQL format, then click Go.

Editing Records

Click on a table name, then click Browse to view rows. Click the Edit icon next to any row to modify its values directly.

Tips for Advanced Users

Use the Designer tab to visualize table relationships.
Run EXPLAIN on slow queries to identify performance issues.
For large imports, consider using mysqldump via SSH instead.

If you need help with a specific database task, contact our support team and we'll be happy to assist.