How to import a MySQL database backup

If you’re moving your website from an existing hosting provider, or it simply doesn’t have an installation wizard, you may wish to import a MySQL dump file.

To use a database backup, you first need to create a new database and configure your script to use it. Then, to import the database:

  1. Login to the control panel.
  2. Go to phpMyAdmin.
  3. Find the new database in the list and click Connect Now.
  4. Click Import in the top bar.
  5. Select the database backup file to import and click Go.

Uploading large backups

Note that phpMyAdmin has some limits on upload size and import time limits. If you have a large database to import, these limits may prevent phpMyAdmin from being able to import the backup all at once.

To work around this, you can use a tool like BigDump instead. BigDump can split your big database export into smaller batches and upload them separately.