cPanel - Data Bases - 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"
3) Select the database that you will need to import to
4) On the upper bar, click the tab "Import"
5) Click "Browse" and locate the .sql file from your computer
6) Click "Go" so that it is imported into the database
7) And you will see a notification that your database was successfully imported
To Export A Database
1) Log into cPanel
2) Navigate to PhpMyAdmin in the section "Databases"
3) Choose the tables that you need to export, or click "Check All"
4) On the upper bar, click the tab "Export"
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
4) Save it and import it using the instructions provided above
Related cPanel Tutorials and How To Guides
Tips and tricks that will make managing your website easier
Tweet Share Pin Email
Add Comment
This policy contains information about your privacy. By posting, you are declaring that you understand this policy:
- Your name, rating, website address, town, country, state and comment will be publicly displayed if entered.
- Aside from the data entered into these form fields, other stored data about your comment will include:
- Your IP address (not displayed)
- The time/date of your submission (displayed)
- Your email address will not be shared. It is collected for only two reasons:
- Administrative purposes, should a need to contact you arise.
- To inform you of new comments, should you subscribe to receive notifications.
- A cookie may be set on your computer. This is used to remember your inputs. It will expire by itself.
This policy is subject to change at any time and without notice.
These terms and conditions contain rules about posting comments. By submitting a comment, you agree with these rules:
- Although the administrator will attempt to moderate comments, not all comments can be moderated at all times.
- You acknowledge that all comments express the opinions of the original author and not those of the administrator.
- You will not post material which is knowingly false, obscene, hateful, threatening, harassing or invasive of privacy.
- The administrator has the right to edit, move or remove any comment for any reason and without notice.
Failure to comply with these rules may result in being banned from submitting further comments.
These terms and conditions are subject to change at any time and without notice.
SEO Tips and Tricks, Search Engine Optimization
Sitejet vs. WordPress
Sitejet Website Builde
What Are Website Backdoors: Prevention and Removal
Comments