linux mysql convert .sql.tar.gz to csv

Question

I have a .sql.tar.gz file tht ws generated by mysql export

is there any command in linux to convert this sql.tar.gz file to csv?

Thanks

score 1 · Answer 1 · answered Dec 31 '18 at 12:59

1

You can try to export MySQL data as CSV and no need to look for a tool for conversion.

Even if you don't have the original MySQL database table, you can restore the SQL file and then export it as CSV. This is the best way to do it.

answered Dec 31 '18 at 12:59

Khaled

I just have the file now – Born vs. Me Dec 31 '18 at 13:02
Then you need to import it into a MySQL server and generate CSV export from the server. There isn't any other good way to do it. – Tero Kilkanen Jan 02 '19 at 23:22

1 Answers1