2.6.1.2.2.2. Database import via HeidiSQL

Before import:

  • Make sure the database you are importing is in the format sql... If the file is zipped, unzip it.
  • Make sure there are no queries in the imported database like CREATE DATABASEsince databases can be create only through the control panel. 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.

Import

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

Import directly from file

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…»):

Video

Content