phpMyAdmin lets you view and manage your website’s database through your web browser. You can use it to browse tables, export a database backup and run SQL commands.
You can open phpMyAdmin directly from your hosting service in Ecenica Dashboard.
Before you start
You’ll need:
- Access to Ecenica Dashboard.
- A Ecenica hosting service
- Your website’s database name, if your hosting account contains more than one database.
You can browse database records without changing them. Before editing or deleting anything, make sure you have a current database backup.
Open phpMyAdmin
- Log in to Ecenica Dashboard.
- Click Services > My Services.
- Click Manage next to your Ecenica web hosting service.
- Click phpMyAdmin.
Select your website’s database
The left-hand panel in phpMyAdmin lists the databases available to your account.
- Find your website’s database name in the left-hand panel.
- Click the database name.
- Check the list of tables displayed in the main panel.
A database stores information in tables. For example, a WordPress database contains tables for posts, settings and user accounts.
If database names are grouped together in the left-hand panel, expand the group to see the individual databases.
Check the database name before making changes. Your hosting account may contain separate databases for different websites or staging copies.
Find your WordPress database name
For a WordPress website, the database name is stored in its wp-config.php file.
- Open File Manager for your hosting service.
- Open your WordPress installation folder, which contains
wp-admin,wp-contentandwp-includes. - Open
wp-config.phpto view its contents. - Find the line containing
DB_NAME. - Note the database name without changing the file.
- Return to phpMyAdmin and select that database.
For example, if the file contains define( 'DB_NAME', 'example_wordpress' );, select the database named example_wordpress.
The file also contains database credentials. Do not share its contents or include passwords in screenshots.
See How to use File Manager on cPanel for help opening your website files.
Browse a database table
After selecting your database:
- Find the table you want to view in the main panel.
- Click Browse next to the table.
- Use the page controls to move through its records.
For WordPress, table names often start with wp_, such as wp_posts or wp_options. Your website may use a different prefix.
Click Structure to view the table’s columns and indexes. Browsing records and viewing the structure do not change the stored data.
Export a database backup
You can download a database export before making changes.
- Select the database name in the left-hand panel.
- Click Export.
- Select Quick as the export method.
- Select SQL as the format.
- Click Export or Go, depending on your phpMyAdmin version.
- Save the downloaded file somewhere secure.
Select the database itself before exporting if you want all its tables. Selecting an individual table exports only that table.
A database export does not include your website files, such as uploaded images, themes or plugins. Very large databases may need another backup method if the export times out.
Open the SQL tab
The SQL tab lets you enter database commands. These can read, update or delete information.
- Select the intended database.
- Click SQL.
- Paste the command supplied by your developer or support guide.
- Check the database name, table names and command carefully.
- Click Go to run it.
Only run commands you understand or have received from a trusted source. Commands containing DELETE, DROP, TRUNCATE or UPDATE can permanently change your website’s data.
Frequently asked questions
Why can’t I find my database?
Check that you opened phpMyAdmin from the correct hosting service. If you still cannot find it, contact Ecenica support with your website address.
Which database should I select?
Use the database name recorded in your website’s configuration file. For WordPress, check the DB_NAME setting in wp-config.php.
Does opening phpMyAdmin change my website?
No. Opening phpMyAdmin, selecting a database and browsing records do not change your website.
What should I do if phpMyAdmin shows a login error?
Return to the Ecenica Dashboard and open phpMyAdmin again from your hosting service. Contact Ecenica support if the error continues.