The phpMyAdmin option can be used to backup all databases on a server that has limited MySQL disk usage. This has the extra advantage of helping you download the database backup from the server itself.
To begin with, follow these steps:
1. Log in to WHM as the root user.
2. Once you’ve logged in, you’ll see a search icon. A drop-down list will be displayed on your screen when you search for SQL Services. Select phpMyAdmin.
3. This screen will appear after you enter phpMyAdmin.
4. Select the database(s) that you want to backup.
- Click on the individual database that you want to backup.
- To back up all databases select nothing.
5. Click on the Export button.
Note: you’ll be unable to backup MySQL system tables using this process. Instead, choose the MySQL database in phpMyAdmin, then Export to generate a backup. phpMyAdmin can also export in several other formats alongside different customizations. Make sure that an uncompressed backup is generated by the default settings using the .sql extension.
6. Select SQL in the Format section.
7. Click on Go.
In this way, you can take MySQL backups with phpMyAdmin.
