import Mysql dump file failed

Options
UserBird
UserBird Dataiker, Alpha Tester Posts: 535 Dataiker
Hi, I want to import a dump mysql file but it never generated a preview.

What I did:

I've tried with .sql and .dump file, and in the preview page I chose type mysql dump and entered the table name . Then I clicked on Create, and it failed with no contents no rows.

What should the file be like? How should I import it?

Thank you
Tagged:

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer Posts: 753 Dataiker
    Options
    When you import a SQL dump file, it is simply a Filesystem dataset in DSS, not a SQL one. If you want to run SQL queries on it, you'll need to sync it into a SQL dataset (add a SQL connection, click the filesystem dataset, and choose actions > sync).

    However, if you already have a MySQL dump file and a MySQL database, it would be much better to load the dump file directly in MySQL
  • WBHHH
    WBHHH Registered Posts: 1 ✭✭✭✭
    Options
    thanks very much!
Setup Info
    Tags
      Help me…