phpMyAdmin lets you manage your databases from your browser, including importing a database from another host and exporting a copy for safekeeping.
Importing a database
- Create an empty database and user first. See Creating a MySQL database and user.
- In cPanel, open Databases › phpMyAdmin.
- Click the database name in the list on the left.
- Open the Import tab and click Choose File.
- Select your
.sqlor.sql.gzfile and click Import at the bottom of the page.
Compressing the file as .sql.gz makes the upload much faster. If the import stops with a size or time-out error, open a support ticket and attach a download link to the file; we will import it for you.
Exporting a database
- In phpMyAdmin, click the database name on the left.
- Open the Export tab.
- Keep Quick and the format SQL, and click Export.
Alternatively, download any database in one click from cPanel under Files › Backup › Download a MySQL Database Backup.