Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

import Mysql dump file failed

import Mysql dump file failed
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
0 Kudos
2 Replies
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
Level 1
thanks very much!
0 Kudos


Labels (2)
A banner prompting to get Dataiku