How do I Backup a MySQL Database?

This article shows you how to take backup of a MySQL database. Taking 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.

Step 1 – Login to cPanel.

Login to cPanel.

Step 2 – Click on to  phpMyAdmin under database section.

Click on to  phpMyAdmin under database section.

Step 3 – Click the Database on left top.

Click the Database on left top.

Step 4 – Click the Export tab

Click the Export tab

Step 5 – Hit the Go button at the bottom right.

Hit the Go button at the bottom right.

Step 6 – Choose the location to save to and click Save.

Step 7 – Your databases have now been exported.

 

Rate This Article

(0 out of 0 people found this article helpful)

Leave A Comment?