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:
- Login to the control panel.
- Go to phpMyAdmin.
- Find the new database in the list and click Connect Now.
- Click Import in the top bar.
- 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.