We use cookies
We use cookies to optimize our website. By continuing to browse the site, you agree to our use of cookies.
New design
Control panel
  • Русский
  • Українська
  • English
  • UAH
  • USD
  • RUB
  • EUR
  • 0-800-307-307 Hotline
  • +38 (044) 392-74-33 Kiev
  • +38 (057) 728-39-00 Kharkiv
  • +38 (056) 794-38-31 Dnipro
  • +38 (032) 229-58-93 Lviv
  • +38 (048) 738-57-70 Odessa
  • +38(093) 170-15-42  Life
  • +38 (067) 400-88-44 Kievstar
  • +1(888)393-24-51  USA, Toll free
  • +44(131)507-01-14  Great Britain
  • +7 (499) 348-28-61 Moscow

2.7.2.2.2. Database import via HeidiSQL

Before import:

  • Make sure the database you are importing is a SQL file. If the file is zipped, unzip it.
  • Make sure there are no queries in the imported database like CREATE DATABASE1)... If there are such requests, the lines with them must be removed from the file using any text editor (for example, Notepad++).
  • If the database to be imported into has not yet been created in the control panel, create it.
  • If the database to be imported into must be empty, clean it up.

To import a database via HeidiSQL, do the following:

  1. Select a database from the list on the left:
  2. On the menu "File» («File") Select"Load SQL file…» («Upload SQL file…») Or press the combination Ctrl+O:
  3. Select the database dump file.
  4. Click "Execute SQL…» («Execute SQL…») (Button with a blue triangle) or the key F9:

If the imported database dump is large enough and you are having difficulty loading it into HeidiSQL, try running the import directly from the file. To do this, in the menu ("File") Instead of"Load SQL file…» («Upload SQL file…") Use"Run SQL file…» («Execute SQL file…»):


1)
You can create databases only through the hosting control panel by instructions.