Importing a database in ISPmanager
Import loads a dump — an .sql file with tables and data — into a database on the hosting. It is a normal step of moving a site: files go to the site folder, the dump goes to the database. The same way you restore a database from your own copy.
Preparation
- Create the database if it does not exist yet: create a database. It is best to load a dump into an empty database.
.sqlfiles and compressed.sql.gzfiles are accepted.- If the dump starts with
CREATE DATABASEorUSE db_namelines, delete them. Otherwise the import tries to write to another database and stops with an access error.
Upload the dump
- "Databases" → tick the database.
- Click "Dump" → "Import".

- "Upload type": "Local computer file".
- Click "Select file" and choose the dump.
- Click "Upload".

"Upload type" also offers other sources: a file by URL or a file already uploaded to the hosting with the file manager or FTP. For large dumps this is more reliable than uploading through the browser.
Tables with the same names are replaced. Export the current database first: export.
A large dump in the Shell client
Upload the dump with the file manager, open the panel Shell client, go to the folder with the file and run:
mysql -u USER -p DB_NAME < dump.sql
# compressed dump:
gunzip < dump.sql.gz | mysql -u USER -p DB_NAMEAfter the import
- Put the database name, user and password into the site settings.
- If the domain changed, update the site address in the CMS.
- Delete the dump from the site folder: it contains all site data.
A "Duplicate entry" error means the database already has this data. Load the dump into an empty database or delete the old tables.