If you want to back up your database or transfer it from one server to another, you can use phpMyAdmin for export and import. Here you will find step-by-step instructions on how to export and import a MySQL database with phpMyAdmin.
Exporting a database with phpMyAdmin
Step 1: Open phpMyAdmin
Log in to MyPanel
Navigate to Hosting
Click on the Database tab
Then click on phpMyAdmin
Step 2: Select the database
In the left column, select the database you want to export.
Step 3: Export the database
Click on the Export tab at the top.
Choose the SQL format, as this is the most common format for exporting and importing databases.
Click OK to start the export. The SQL file will now be downloaded to your computer.
Importing a database with phpMyAdmin
Step 1: Open phpMyAdmin
Log in to phpMyAdmin on your new server or with your new database.
Step 2: Import
Select the corresponding database.
Click on the Import tab at the top.
Choose the previously exported SQL file from your computer.
Leave most settings as default unless you have special requirements.
Click OK to start the import.
