Import Export Databases with phpMyAdmin

cPanel How-To's Tutorials

Frequently Asked Questions

Updated: April 4, 2019
By: RSH Web Editorial Staff
cpanel faq

cPanel

F A Q's

phpMyAdmin

How to import and export database via phpMyAdmin ("Access denied create database db_name" error)

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 50MB 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 submit a ticket to our HelpDesk.

To import a database:

• Log in your cPanel.

• Navigate to PHPMyAdmin in the section 'Databases'

cPanel

Select the database that you will need 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

What is cPanel Website Hosting
Do I Need a Website Redesign?
Why Web Security is Important


Tweet  Share  Pin  Tumble  Email

Simple, Fast and Secure cPanel Hosting

45 Day Unconditional Guarantee  On all Hosting Packages  No questions asked

1997 - 2019  |  RSH Web Services  |  All Rights Reserved.