import Mysql dump file failed

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


  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer Posts: 753 Dataiker
    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 Registered Posts: 1 ✭✭✭✭
    thanks very much!
Setup Info
      Help me…