2.6.1.2.1.4. Import database using phpMyAdmin

Before importing:

  • Make sure the database you are importing is a file in the sql format. If the file is compressed, extract it. Please note that the .tar.gz extension indicates a compressed archive, and importing a file with this extension may result in numerous errors.
  • Make sure the file size does not exceed 300 MB. If the file is larger, use one of the methods for importing databases of any size described here.
  • 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.
  1. Log in to phpMyAdmin.
  2. Select the database from the list on the left:
  3. On the "Import" tab, select the database dump file and click "Import":
Content