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.
Step 2 – Click on to phpMyAdmin under database section.
Step 3 – Click the Database on left top.
Step 4 – Click the Export tab
Step 5 – 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.