Exporting a table from Amazon RDS into a CSV file

Question

I have a MySQL database running in Amazon RDS, and I want to know how to export an entire table to CSV format.

I currently use MySQL server on Windows to query the Amazon database, but when I try to run an export I get an error, probably because there's no dedicated file server for amazon RDS. Is there a solution to this?

Answer 1

Presumably, you're attempting to export data from an Amazon RDS database using a SELECT... INTO OUTFILE query, which results in this issue, which is rather typical (see, for example, export database to CSV). The response from the AWS team confirms your assumption that you don't have server access, which prevents you from exporting your data, and also suggests an alternative method of exporting your data in CSV format by selecting the data in the MySQL command line client and piping the output to reformat the data as CSV.