Learn how to open phpMyAdmin through cPanel and access your databases. With phpMyAdmin, you can edit tables and data, run SQL queries, and import or export data.
Who is this guide for?
This guide applies exclusively to customers whose hosting with cPanel is managed on the new Webland platform (WHMCS).
Do you use Essential Hosting without cPanel? Follow the guide “Essential Hosting: Creating and Managing Databases”, which explains how to access database management for your plan.
Do you use the System Configurator or Domain Manager? Sign in at classic.webland.ch. The steps below do not apply to the classic Webland platform.
Important information
Use phpMyAdmin to manage existing databases and their contents. Create new databases and database users through Database Wizard or Manage My Databases so that cPanel associates them correctly.
Saved changes and executed SQL commands can affect your website immediately. Create a current database backup before changing or deleting data or performing an import.
Requirements
You have an active hosting service with cPanel and database functionality.
At least one database has been created in your hosting account.
You have the required access permissions.
1. Sign in to cPanel
Open the home page (dashboard) in the Webland client area.
Find the relevant hosting plan under your active services.
Click Log in to cPanel.
2. Open phpMyAdmin
In cPanel, open phpMyAdmin under Databases. Alternatively, use the cPanel search.
You will be signed in to phpMyAdmin automatically. You normally do not need to enter a separate database password when accessing it this way.
3. Select the correct database
The menu on the left lists the available databases. Click the database you want to manage.
Its tables appear in the main area.
Check the database name before making changes. For WordPress, you can find it in the wp-config.php file under DB_NAME.
4. Choose the appropriate function
The available functions depend on whether you have selected a database or an individual table.
Function | Purpose |
Browse | View records in the selected table. |
Structure | Review and manage a database’s tables or a selected table’s columns and indexes. |
SQL | Run SQL queries in the selected database or table context. |
Import | Import data from a file into the selected database or table. |
Export | Export the selected database or table to a file. |
To view records, first open the relevant table and select Browse.
5. Export a database
To back up the entire database:
Select the database on the left, rather than an individual table.
Open Export.
Select SQL as the format.
Make sure all required tables, including their structure and data, are included.
Start the export and store the downloaded file securely.
This export only backs up the selected database content and structures. It does not include website files such as images, plugins or themes.
6. Import data
Select the correct target database first.
Open Import.
Select the file and the appropriate format.
Review the settings and start the import.
Check the resulting success or error message.
Depending on the file’s contents, an import can add to, replace or delete existing tables and data. Check the target database and back up its current state before importing.
Frequently asked questions and troubleshooting
My database is not listed.
Check that you opened cPanel for the correct hosting plan. Under Manage My Databases, check whether the database exists.
phpMyAdmin does not open.
Sign out of cPanel and open it again through the Webland client area. If the problem continues, contact our support team and include the error message.
I cannot find “Browse”.
Select a table first. Browse displays that table’s records; it is not a general view of all content in a database.
The import fails or the file is too large.
Check the displayed maximum upload size and the exact error message. Large databases may require another import method. Contact our support team for assistance.
Is a database export a complete website backup?
No. A complete restore also requires the website files. For WordPress, follow “cPanel: Backing Up and Restoring WordPress with WP Toolkit”, provided that feature is available with your plan.