import Mysql dump file failed

Highlighted
UserBird 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
Clément_Stenac Dataiker
Dataiker
Re: import Mysql dump file failed
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
Re: import Mysql dump file failed
thanks very much!
0 Kudos
Labels (2)