Join us on Wednesday, June 3rd for a deep dive into Customer Predictive Analytics Learn more

import Mysql dump file failed

Dataiker
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
Dataiker
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
Level 1
thanks very much!
0 Kudos
Labels (2)