Export the database via cPanel
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 2: Select the option phpMyAdmin under the section Databases
Step 3: A list of databases will be viewed in the left pane and click the database on the left top
Step 4: Select the Export tab from the list of menus at the top
Step 5: Select the valid SQL format from the list of drop-down menu for exporting the database
Step 6: After the selection of the valid format, click the button Go at the bottom
Step 7: Now the database is automatically exported to the local system
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.
Click on to phpMyAdmin
Step 3 It shows the list of the database available under your cPanel. Click the Database on left top.
Choose the Database
Step 4 Click the Export tab from the list of menus at the top.
Click Export menu
Step 5 Select the valid sql format from the drop down list for exporting the database.
Select the valid sql format
Step 6 After the selection of valid format, click the Go button.
Click 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.
Video Tutorials