2.6.1.2.2.2. Import database using HeidiSQL

Before importing:

  • Make sure the database you are importing is a file in the sql format. If the file is compressed, extract it.
  • Make sure the database you are importing does not contain any queries like CREATE DATABASE, as databases can only be created via the control panel. If such queries exist, you must delete the lines containing them from the file using any text editor (for example, Notepad++).
  • If the database into which the import will be performed has not yet been created in the control panel, create it.
  • If the database into which the import will be performed needs to be empty, clear it.

Import

  1. Connect to the database.
  2. Select the database from the list on the left:
  3. In the "File" menu, select "Load SQL file" or press Ctrl+O:
  4. Select the database dump file.
  5. Click "Execute SQL" (the button with the blue triangle) or press the F9 key:

Import directly from file

If the database dump you're importing is quite large and you're having trouble loading it into HeidiSQL, try running the import directly from the file. To do this, in the "File" menu, select "Run SQL file" instead of "Load SQL file":

Content