Search The Hostwinds Guides Knowledge Base

Database Backup using PHPMyAdmin

Share This Article [TheChamp-Sharing]

This article is about taking a backup of your database and is intended for clients who have PHPMyAdmin installed on their Hostwinds Shared Hosting, Business Hosting, Cloud, VPS or Dedicated Server account. Before making any changes to your databases or updating your applications, or making any significant changes, it is important to always take a backup. Hostwinds suggests taking a backup of your database frequently so that you can easily restore your database at any time and in case anything goes wrong.

How To Backup Your Database Using cPanel and PHPMyAdmin

Step One: Login into your cPanel Account

Step Two: Navigate to the Databases section and click phpMyAdmin

cpanel phpmyadmin databases

Step Three: Click on the database name on the upper left side of the page that you would like to create a backup for

Step Four: Click on Export in the top middle part of the page

export database using phpmyadmin

Step Five: Select the Export method that you would like to use, the format and click the Go button

export database using phpmyadmin

This will create the backup file and download it to your computer so that you have a backup.

Backup Database Using Cron

Step One: Login to your cPanel Account

Step Two: Scroll down to the Advanced Section > Click on Cron Jobs

create cron job to backup cpanel database

Step Three: Scroll down to the Common Settings

Step Four: Select the frequency to create your database backups, or enter this in manually

Step Five: Enter in the Command to run to backup your databases

mysqldump --opt -Q -u [cPanelUserName] -p[cPanelPassword] --all-databases > /home/[cPanelUsername]/[FILE_NAME]_`date +\%d\%m\%y`.sql

Replace the following in the above cron job with your account specific details:

Step Six: Click the Add New Cron Job button

Step Seven: Once this cron job has been created, you can check and confirm that the file exists in your home directory and that everything is working as expected.

Related Articles

If we can help you in any way, please submit a ticket or join us in a Live Chat anytime. We are available 24/7/365 and we are dedicated to our client’s success; every client truly matters to us.