How to import a MySQL database (.sql file) and size limits

For hosting customers · Updated 2026-10-29

On this page
  1. Before you start
  2. Import with phpMyAdmin (up to 512 MB)
  3. Import a larger file over SSH
  4. Limits
  5. Common questions

To move a website here, you import its database dump (a .sql file) into a new, empty database. phpMyAdmin handles files up to 512 MB; for larger files use the command line.

Before you start

  • Create the database and user and add the user to the database.
  • If the file contains CREATE DATABASE or USE lines, remove them, or make sure they use your new database's full name (username_name). You cannot create databases from the import.

Import with phpMyAdmin (up to 512 MB)

  1. Log in to the control panel (https://<server>:2083).
  2. Open MySQL Databases (section Databases) and click Open phpMyAdmin.
  3. Click your database on the left.
  4. Open the Import tab.
  5. Click Choose file and select the .sql file. A compressed .sql.gz or .zip uploads faster.
  6. Click Import at the bottom.

phpMyAdmin shows "Import has been successfully finished" and the tables appear on the left.

Import a larger file over SSH

If your plan has shell access:

  1. Upload the file to your home folder with SFTP, for example as ~/backup.sql.
  2. Open Terminal in the control panel, or connect with SSH.
  3. Run, with your own names:
    mysql -u username_shop -p username_shop < ~/backup.sql

    Enter the database user's password when asked.

For a compressed file:

gunzip < ~/backup.sql.gz | mysql -u username_shop -p username_shop

Delete the dump file afterwards; it takes disk space and contains your data.

Limits

MethodLargest fileTime limit
phpMyAdmin512 MB per upload10 minutes
mysql over SSH or Terminalyour disk spacenone (Terminal: session limits apply)

Common questions

The import fails with "#1044 - Access denied for user … to database …". Why?

The file tries to create or switch to a database with another name. Remove the CREATE DATABASE and USE lines from the file and import into your selected database.

The import stops with "#1062 Duplicate entry". What does that mean?

The database is not empty. Import into an empty database, or drop the existing tables first.

How do I import without shell access if the file is over 512 MB?

Split the dump into smaller files on your computer and import them one by one, or ask your hosting provider.

Was this article helpful?

Still stuck?

Ask the AI about your exact situation — it answers from this knowledge base — or contact us.