Importing or exporting a database with phpMyAdmin Print

  • phpmyadmin, import, export, database, sql
  • 0

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

  1. Create an empty database and user first. See Creating a MySQL database and user.
  2. In cPanel, open Databases › phpMyAdmin.
  3. Click the database name in the list on the left.
  4. Open the Import tab and click Choose File.
  5. Select your .sql or .sql.gz file 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

  1. In phpMyAdmin, click the database name on the left.
  2. Open the Export tab.
  3. 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.


Was this answer helpful?

« Back