search

duckdb / duckdb_mysql

https://duckdb.org/docs/extensions/mysql
MIT License
51 stars 12 forks source link

Read mysqldump #2

Closed matinnuhamunada closed 11 months ago

matinnuhamunada commented 12 months ago

Is it possible to read a mysqldump file into DuckDB?

szarnyasg commented 12 months ago

@matinnuhamunada I don't think this is possible at the moment. Can you export to CSVs? With that, you can likely go a long way using the DuckDB CSV reader's automatic schema detection: https://duckdb.org/docs/data/csv/overview.html

Mytherin commented 11 months ago

This is out-of-scope for this extension in any case - although you could read mysqldump into MySQL, and then use this extension to transfer data from MySQL into DuckDB