Export the Database via cPanel
A backup process refers to the copying the data from source to destination. It may be used to original after a data loss. Backup is the important thing to manage your data on the server. There are multiple options available to backup the database. This article shows you how to take backup of a MySQL database. Taking a backup of MySQL database is mainly for two reasons.
- Security purpose
- Database Migration
There are two ways to go about backing up your MySQL databases.
- Use backup utility in the cPanel.
- Manually backup using phpMyAdmin. To do this, follow the steps below.
In this article shows how to backup the database via Mysql. This also called as export the database. This is the easiest way to export the database from your cPanel. We have the option to export the database through phpmyadmin. Its a database management tool which will help to export the database via cPanel. To export a database via cPanel, follow the below steps
Step 1 Login to cPanel, via your domain url otherwise you can directly access your cPanel through our server url.
Step 2 Click on phpMyAdmin under database section which will help to manage all your Mysql database.
Step 3 It shows the list of the database available under your cPanel. Click the Database on left top.
Step 4 Click the Export tab from the list of menus at the top.
Step 5 Select the valid sql format from the drop down list for exporting the database.
Step 6 After the selection of valid format, click the Go button.
Step 7 Done. Now the database automatically exported to your local system.
This is only possible if you have the backup file on your computer. At some occasions you may accidently delete some important files from your website or an email, you don’t worry we can get it back by restoring it from the backup stored in your computer. If you are hosting your website in a good hosting provider then they will keep a daily backup of your website. You can request for the backup files to your hosting provider and they will send it to you.