Import a MySQL database
- Log in to your cPanel service.
- Click the phpMyAdmin icon.
- Using the left menu of phpMyAdmin, select the database you wish to import your data to.
- Now that you’re viewing the particular database, click the Import tab.
- There you will click Browse to select the file to upload, select the appropriate character set (if in doubt, leave as utf-8) and tweak the additional settings if required; then click Go.
- The file will then be imported, perhaps taking some time depending on file size; the outcome of the import will then be confirmed to you.
If your database is quite large (in excess of 50MB) you cannot import this manually through phpMyAdmin. Instead, upload it through cPanel’s Backup Wizard tool.
Export a MySQL database
- Log in to your cPanel service.
- Click the phpMyAdmin icon.
- Using the left menu of phpMyAdmin, select the database you wish to export.
- Now that you’re viewing the particular database, click the Export tab.
- Choose your export method (Quick is generally the norm) and select the format to export it as (typically SQL); then click Go.
- This will give you a download prompt confirming where to download it to on your computer.