HostSEO Blog

Stories and News from IT Industry, Reviews & Tips | Technology Blog


How to import and export a database via phpMyAdmin (

  • Category : MySQL Question
  • Posted on : Apr 18, 2021
  • Views : 1,021
  • By : HostSEO

In cPanel you can import and export databases using the phpMyAdmin menu which you can find in the Databases section. Note, that only databases of 1 GB 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.


Database import

1. Log into your cPanel

2. Navigate to phpMyAdmin menu.
 
You can use our cPanel Shortcuts in the Namecheap account for quick access.




3. Select the database that you will need import to:



4. In the upper bar, click the tab Import:



5. Click Browse and locate the .sql file from your computer. Once done, click Go:



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




Database export

1. Log into your cPanel
2. Navigate to phpMyAdmin menu:



3. Select the database that you will need import to:



4. Choose the tables that you need to export or click Check All. Click Export to proceed:



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




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:

1. Open the dump of your database using any text editor on your computer (for instance, Notepad or WordPad).
2. Find the line: CREATE DATABASE db_name (it can usually be found at the beginning) and remove it.
*db_name â$“ your database name:

how_to_import_and_export_database_in_cpanel_access_denied_create_database_db_name_error_and_how_to_fix it(10).jpg

3. Save it and import it using the instructions provided above.


That's it!

              
                      Need any help? Contact our HelpDesk

 

 

Subscribe Now

10,000 successful online businessmen like to have our content directly delivered to their inbox. Subscribe to our newsletter!

Archive Calendar

SatSunMonTueWedThuFri
 123456
78910111213
14151617181920
21222324252627
28293031 

Born in 2004 ... Trusted By Clients n' Experts

SEO Stars

They never made me feel silly for asking questions. Help me understand how to attract more people and improve my search engine ranking.

Read More

Emily Schneller Manager at Sabre Inc
SEO Stars

Took advantage of Hostseo's superb tech support and I must say, it is a very perfect one. It is very fast, servers reliability is incredible.

Read More

Leena Mäkinen Creative producer
SEO Stars

We're operating a worldwide network of servers with high quality standards requirements, we’ve choose hostseo to be our perfect partner.

Read More

Ziff Davis CEO at Mashable
SEO Stars

It’s very comfortable to know I can rely about all technical issues on Hostseo and mostly that my website and emails are safe and secured here.

Read More

Isaac H. Entrepreneur
SEO Stars

With hostseo as a hosting partner we are more flexible and save money due to the better packages with great pricing, free SEO n' free SSL too!

Read More

Madeline E. Internet Professional