2.6.1.2.3.2. Import database using Sequel Pro

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 DATABASE1). 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. Connect to the database.
  2. Press the ⇧+⌘+I shortcut or click "File → Import…" in the top menu:
  3. Select the database dump file, configure the import settings, and click "Open":
    • "Format" — make sure "SQL" is selected.
    • "Encoding" — leave it set to "Auto-detect" or select the desired encoding.
    • "On SQL Error" — select "Ask me what to do".
1)
You can only create databases via the hosting control panel by following the instructions
Content