Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

import Mysql dump file failed

UserBird
Dataiker
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
Clément_Stenac
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
Level 1
thanks very much!
0 Kudos

Labels

?
Labels (2)
A banner prompting to get Dataiku