2.7.2.4.2. Database import via Sequel Pro

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