CODEWITHSUNDEEP
phpmysqlcsvfwritefputcsv
Kamar Khan
Kamar Khan

Reputation: 1

mysql to csv without using INTO OUTFILE of mysql

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.

Upvotes: 0

Views: 1396

Answers (1)

Michael Mior
Michael Mior

Reputation: 28772

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

Upvotes: 0

Related Questions