Steps to Backup Mysql Database Using PHPMyAdmin
1. Firstly, Log into PHPMyAdmin. (You can get your PHPMyAdmin URL inside your cPanel / HELM / Plesk)
2. Select the database which you wish to backup from the drop down database menu at the left.
3. Click on “Export” tab.
4. Next, Select Mysql database table which you wish to export.
5. Select Export Options.
6. Enter a filename and compressions format.
7. Last, Click “Go”.
– If you select Compressions = None, a query windows will appear and displaying the raw Mysql query of your exported tables.
– If you select Compressions = “Zipped” or “GZipped”, a pop up box will appear asking you to save the .sql file into your local drive.
You’re sucessful to backup Mysql Database using PHPMyAdmin. If you found this guide useful during the setup of your additional address. Please share it with other users going through the same process.
Please refer to the following article to know more.
Knowledge Base: Changing Collation in PhpMyAdmin