Hi,

I have mysql database dump xxx.sql
How can i convert xxx.sql to xxx.csv?

Thanks

Recommended Answers

All 3 Replies

Import .sql to MySQL and then export it via any GUI tool or export as CSV with a simple PHP script.

I don't know any tool which can directly convert .sql to .csv.

Yes you are right.

run this query:
SELECT *
FROM TABLE_NAME
INTO OUTFILE '/tmp/xyz.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.