2.6.1.1.6. Importing a database through the control panel

From file

Important points:

  • The file must be in SQL format.
  • The file size must not exceed 300 MB. For larger sizes, use alternative import methods.
  • The dump file should not contain queries like CREATE DATABASEsince databases can be create only through the control panel. If there are such requests, the lines with them must be deleted using any text editor (for example, Notepad++).
  • The database user password must not contain a character #. If there is such a symbol change password to another without this symbol.
  1. Open the section «Databases».
  2. Expand the database menu where you want to import and click «Import database».
  3. Fill out the form and click «Import»:
    • «Where» — «Dump file».
    • «File» - select the file with the database dump.
    • «File encoding» - use «Do not specify encoding when importing» or select the desired encoding from the list.
    • «Where» - target database and its user.
    • «Continue importing data if an error occurs» — enable, if necessary, so that the import does not stop in case of any errors.
    • «Clear database content before import» — enable if the import should be performed into an empty database (all existing data from the selected database will be deleted).
  4. Wait for the operation to complete. During the import process, it will open file-manager and in his block of operations the current status will be displayed.

From hosting

The method is suitable for cloning existing databases.
  1. Open the section «Databases».
  2. Expand the database menu where you want to import and click «Import database».
  3. Fill out the form and click «Import»:
    • «Where» — «Database».
    • «Hosting account» — hosting account with the original database.
    • «Database» — the source database in the selected hosting account.
    • «Where» - target database and its user.
    • «Continue importing data if an error occurs» — enable, if necessary, so that the import does not stop in case of any errors.
    • «Clear database content before import» — enable if the import should be performed into an empty database (all existing data from the selected database will be deleted).
  4. Wait for the operation to complete. During the import process, it will open file-manager and in his block of operations the current status will be displayed.

From external server

Important points:

  • The server must be allowed external connections and should not be restricted by IP.
  • The database user on the server must have all the privileges required to perform the import.
  1. Open the section «Databases».
  2. Expand the menu of the database you want to import into and click «Import database».
  3. Fill out the form and click «Import»:
    • «Where» — «External server».
    • Specify access data to the source database:
      • «Server» — address of the server (host).
      • «Port» - port number (default is the standard port 3306).
      • «Database» - the name of the database.
      • «User » is the database username.
      • «Password» — database user password.
    • «Where» - target database and its user.
    • «Continue importing data if an error occurs» — enable, if necessary, so that the import does not stop in case of any errors.
    • «Clear database content before import» — enable if the import should be performed into an empty database (all existing data from the selected database will be deleted).
  4. Wait for the operation to complete. During the import process, it will open file-manager and in his block of operations the current status will be displayed.
Content