New design

Control panel

Русский
Українська
English

Support chat

Select the type of request:

Continue in telegram

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 DATABASE¹⁾... 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:

Connect to database.
Select a database from the list on the left:
On the menu "File» («File") Select"Load SQL file…» («Upload SQL file…») Or press the combination Ctrl+O:
Select the database dump file.
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…»):

¹⁾

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

2.7.2.2.2. Database import via HeidiSQL

Before import:

Import

Import directly from a file

Videoinstruction