mysql to csv without using INTO OUTFILE of mysql

Question

I need to export data from mysql to a csv file with column heading but i dont have file permission on the server. Is there any otherway to do it? i.e. using php fwrite? or fputcsv?

Any help will be much appriciate.

Thanks.

Hi thanks, Is it possible to give detail example? I am not expert on this things. Thanks in advance. — Kamar Khan
– Kamar Khan, Commented Oct 1, 2010 at 14:42

Michael Mior · Accepted Answer · 2010-10-01 01:23:19Z

0

If you can connect to the MySQL server, you can run the mysqldump utility, which is capable of generating CSV files. This is far easier than trying to come up with something yourself.

mysqldump --tab --fields-terminated-by="," --host=$SERVER --user=$USERNAME --password=$PASSWORD $DATABASE

answered Oct 1, 2010 at 1:23

Michael Mior

28.9k10 gold badges95 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Kamar Khan Over a year ago

Thank you for quick response mr Michael Mior where it will save the file? Is there a way to specify a file name for output?

Michael Mior Over a year ago

The file will get written to standard output. If you want to save to a file, just redirect by adding ` > filename` to the end.

Lauri Piispanen Over a year ago

It is specifically stated that the user doesn't have FILE permission on the mysql server. mysqldump --tab option uses SELECT INTO OUTFILE which requires this permission. This answer therefore will not work in the given situation.

Collectives™ on Stack Overflow

mysql to csv without using INTO OUTFILE of mysql

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related