2.6.1.1.6. Import database to hosting account

Alternative import methods

To import a database, you can use the file manager, console, phpMyAdmin (for SQL files up to 300 MB) or any MySQL client (e.g., HeidiSQL).

flowchart LR subgraph "💻 Local device" f@{ shape: bow-rect, label: "📄 Dump file" } end subgraph "👤 Account" subgraph "☁️ Other hosting account" h@{ shape: cyl, label: "🗄️ Database" } end subgraph "🐬 MySQL instance" m@{ shape: cyl, label: "🗄️ Database" } end subgraph "☁️ Hosting account" db1@{ shape: cyl, label: "🗄️ Database" } db2@{ shape: cyl, label: "🗄️ Other database" } end end subgraph "🖥 External server" e@{ shape: cyl, label: "Database" } end f---->db1 h--->db1 db2-->db1 m--->db1 e---->db1

  1. Open the "Databases" section.
  2. In the menu of the database you want to import to, click "Import database":
  3. Fill out the form and click "Import":
    • Import destination — where to import:
      • Database user — user on whose behalf the import will be performed.
    • Import source — where to import from:

      Important points:

      • The file must be in SQL format. The file may be contained in a .TAR.GZ or .GZ archive. If using .TAR.GZ, the first SQL file in the archive is selected.
      • Maximum file size — 50 GB. However, please note that you will not be able to import more data than the free space available in your hosting account.
      • There should be no CREATE DATABASE queries in the dump file, since databases can only be created via the control panel. If there are such queries, the lines with them should be deleted using any text editor (e.g. Notepad++).
      • The database user password must not contain the # character. If there is such a character, change the password to another one without this character.
      • From — Dump file.
      • File — file with the database dump to be imported.
      • File encoding — use Do not specify encoding when importing or select the desired encoding from the list.
      The method is suitable for cloning existing databases.
      • From — Database.
      • Service — Hosting account.
      • Hosting account — hosting account with a database to be imported.
      • Database — database to be imported.
      The method is suitable for migrating databases from a MySQL instance.
      • From — Database.
      • Service — MySQL.
      • Instance — instance with the database to be imported.
      • Database — database to be imported.

      Important points:

      • External connections must be allowed on the external server and there must be no IP restrictions.
      • The database user on the external server must have all privileges necessary to perform the import.
      • From — External server.
      • Server — server (host) address.
      • Port — port number (the default is the standard port 3306).
      • Database — database name.
      • User — database user name.
      • Password — database user password.
    • Continue importing data if an error occurs — enable if you want the import to continue if any errors occur.
    • Clear database contents before import — enable if the import is to be performed to an empty database (the destination database will be cleared before import).
  4. Wait for the operation to complete.
Content
    (2)