Using the phpMyAdmin Feature in cPanel

cPanel tutorials & how to guides
User friendly interface
Rich features set integrated into cPanel

Modify records in a MySQL database

Updated: January 19, 2023
By: RSH Web Editorial Staff
cPanel Tutorials phpMyAdmin
Menu

Data Bases > phpMyAdmin

phpMyAdmin
Written in PHP, it is a third-party tool to manage the tables and data inside a database. phpMyAdmin supports various type of operations on MariaDB and MySQL. The main purpose of phpMyAdmin is to handle the administration of MySQL over the web.

phpMyAdmin

You can use phpMyAdmin to add, modify or delete records in a MySQL database.

For more information about how to use phpMyAdmin, visit the phpMyAdmin website.

How to import and export database via phpMyAdmin

In cPanel, you can import and export databases using the menu phpMyAdmin, which you can find in the section Databases

Please note, only databases of 50 MB maximum, can be imported/ exported in PhpMyAdmin. Larger databases have to be imported/exported via SSH. To do this, follow the instructions here or simply contact RSH Web

To import a database:

• Log in your cPanel

• Navigate to PhpMyAdmin in the section "Databases"

cPanel

Select the database that you will need to import to

cPanel

On the upper bar, click the tab "Import"

cPanel

Click "Browse" and locate the .sql file from your computer

cPanel

Click "Go" so that it is imported into the database

cPanel

And you will see a notification that your database was successfully imported

cPanel

To export a database:

• Log into cPanel

• Navigate to PhpMyAdmin in the section "Databases"

cPanel

Choose the tables that you need to export, or click "Check All"

cPanel

On the upper bar, click the tab "Export"

cPanel

Select the required file from the drop-down menu in "Format" and click "Go" button

If you received this error message, you can resolve the issue by following the next steps:

"Access denied create database db_name" error. How to fix it?

If you received this error message, you can resolve the issue by following the next steps:

• Open the dump of your database using any text editor on your computer (for instance, Notepad or WordPad);

• Find the line : CREATE DATABASE db_name (it can usually be found at the beginning ) (*db_name – your database name ). And delete it

cPanel

Save it and import it using the instructions provided above

Related cPanel Tutorials and How To Guides
Most all website hosting companies now offer cPanel

Tweet  Share  Pin  Tumble  Email

We welcome your comments, questions, corrections and additional information relating to this article. Please be aware that off-topic comments will be deleted.
If you need specific help with your account, feel free to contact us anytime
Thank you

More Articles Of Interest

RSH Web Services offers a wide range of hosting services customized to match your needs, whether you are looking for a personal, professional or business website. Get the full functionality of your hosting services and better control over your site with cPanel