Export table data into csv file using mysqldump?

Check out this link. It shows an alternative to export your table to csv file.

Up vote 0 down vote favorite share g+ share fb share tw.

I want to export a table data into a csv file using mysqldump. I want to make something like: mysqldump --compact --no_create_info --tab=testing --fields-enclosed-by=\" --fields-terminated-by=, -uroot -proot mydatabase mytable but I keep getting this error: (Errcode: 13) when executing 'SELECT INTO OUTFILE' I made my testing folder writable(I'm using Ubuntu as enviornment). Can somenone explain how to export a table in a CSV file, or how to modify my command shell in order to work?

Thanks! Php mysql csv link|improve this question asked Mar 8 at 9:06zuzuleinen4319 64% accept rate.

Check out this link. It shows an alternative to export your table to csv file. Export CSV directly from MySQL I hope that this is helpful.

As you are getting links to other pages, probably let me give you a better one it is a youtube video on how to deal with CSV and mysql using php... Hope it can help youtube.com/watch?v=6OLgjgr6EH4.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.