Menu

cPanel - 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:

1) Log in your cPanel

2) Navigate to PhpMyAdmin in the section "Databases"

Learn how to use cPanel effectively with RSH Web Services. Our beginners guide walks you through key features for seamless website hosting, domain management, and more

3) Select the database that you will need to import to

RSH Web Services’ cPanel guide for beginners helps you unlock essential features, from domain management to hosting settings, for a smoother, more efficient website import

4) On the upper bar, click the tab "Import"

Get started with cPanel hosting today. RSH Web Services provides a beginner’s guide to mastering cPanel features and optimizing your website management tasks sql file

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

Get started with cPanel hosting today. RSH Web Services provides a beginner’s guide to mastering cPanel features and optimizing your website management tasks database

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

Unlock the power of cPanel with RSH Web Services. Explore beginner-friendly features and step-by-step guides to set up and manage your hosting and domains effortlessly imported

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

Get the most out of cPanel hosting with RSH Web Services. Learn beginner tips and tricks for optimizing hosting settings, managing domains, and more in this easy guide successfully imported

To Export A Database

1) Log into cPanel

2) Navigate to PhpMyAdmin in the section "Databases"

RSH Web Services offers a cPanel guide for beginners, understand core features to help you manage domains, emails, and hosting for an optimized website experience

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

export to cPanel

4) On the upper bar, click the tab "Export"

Explore RSH Web Services beginners guide to cPanel features. Learn everything you need to set up, manage, and optimize your website and hosting effortlessly Exported

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

Error Messages

If you received this error message, you can resolve the issue

"Access denied create database db_name" error.

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

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

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

instructions

4) Save it and import it using the instructions provided above

cPanel Learning Resources and How-To Instructions
Industry leading Linux-based website hosting control panel

Tweet  Share  Pin  Email

Add Comment

* Required information
Drag & drop images (max 3)

Comments

No comments yet. Be the first!

Composed by our masterful copywriters

As the leading provider of cPanel hosting solutions, RSH Web Services provides a full range of hosting products for any business, personal or professional website. From domain name registration to high security and easy management