Home WebServer PanelcPanel How to get the website’s database on cPanel hosting

How to get the website’s database on cPanel hosting

by Thạch Phạm

In this article, AZDIGI will help you understand how to get a website’s database on cPanel hosting.

I. Introduction

The database is an extremely important component of a website, a project, an application… And since it is an essential part, regular storage and backup are extremely necessary.

Khuyến mãi Black Friday

However, most newbies do not yet know how to operate and will need assistance from Technical Team.

Understanding customer needs, today AZDIGI will guide you on how to get the website’s database on cPanel hosting.

II. How to get the website’s database on cPanel hosting

Unlike the website source code, we only need to compress the source code with a file management tool that makes backing up the source code much simpler.

In this tutorial, I will show you how to get the website’s database on cPanel hosting in 3 different ways and the complexity will increase gradually.

Method 1: Download the database from the Backup feature

This is the simplest way we can get the database. First, we will access Backup feature as shown below:

How to get the website's database on cPanel hosting

After accessing this feature, you will see Download a MySQL Database Backup as shown below:


There are 2 databases on this hosting, so the list shows 2 databases. If you have more websites or databases, this list will show all your databases.

You just need to click on the name of the database to download, then the browser will automatically download that database to your personal computer. Pretty simple, isn’t it?

anh 1

Method 2: Export database from phpMyAdmin

In this way, you will need to access the phpMyAdmin feature as shown below:

image 4

At phpMyAdmin, click on the database you want to download, and then select Export.

Screen Shot 2022 05 15 at 09.20.56

After selecting Export, select Go and the database will automatically be downloaded.

Screen Shot 2022 05 15 at 09.23.29

Method 3: Export the database with the command at Terminal

Hosting at AZDIGI all open a Terminal command window, so you can use commands: mysqldump or WP-CLI to Export the database.

You can find this feature on cPanel.

image 7

After accessing this feature, you can use the following command to export the database:

AZDIGI Tutorial
mysqldump -u mysql_user -p database_name > file_name.sql

You need to change the contents of mysql_user, database_name, file_name.sql according to the correct database-connection information. After entering this command, you need to enter the password of the corresponding mysql_user, the database will be exported successfully and saved at the root of File Manager.

If you have WordPress websites on your hosting package, you can use the command cd ten_thu_muc to move into that website’s directory. And then, you use the following WP-CLI command to export the database quickly.

AZDIGI Tutorial
wp db export
image 8

. The database when exported will automatically assign the time to the name, so you can set the Cron Job to schedule automatic backups with this command.

III. Summary

Thus, AZDIGI has shown you 3 ways to get the website’s database on cPanel hosting. Depending on your needs, you can choose the most suitable method.

Hope this article is useful to you. Wishing you success!

See more useful cPanel articles at the following link:

If you need support, you can contact support in the ways below:

Đánh giá

Tham gia nhóm hỗ trợ Server - Hosting

Tham gia nhóm Hỗ trợ Server - Hosting & WordPress để cùng nhau hỏi đáp và hỗ trợ các vấn đề về WordPress, tối ưu máy chủ/server.

Tham gia ngay

Bài viết cùng chuyên mục

AZDIGI – Không chỉ là đơn vị hàng đầu trong lĩnh vực Web Hosting và Máy chủ, chúng tôi mong muốn mang lại những kiến thức bổ ích nhất và luôn cập nhật thường xuyên cho cộng đồng người đam mê thiết kế website, công nghệ,…

Vui lòng không sao chép nội dung nếu chưa xin phép. Designed and Developed by PenciDesign