Exporting a table from Amazon RDS into a CSV file

0 votes

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?

Mar 3 in Others by Edureka
• 13,640 points
362 views

1 answer to this question.

0 votes
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.
answered Mar 3 by gaurav
• 13,560 points

Related Questions In Others

0 votes
0 answers

Access Amazon RDS database in VPC from Lambda locally

Is there any way we can access ...READ MORE

Mar 9 in Others by Edureka
• 13,640 points
25 views
0 votes
1 answer
0 votes
1 answer

Change the permission for a file created by me in linux

If you are the system administrator or ...READ MORE

answered Mar 8, 2019 in Others by Nabarupa
328 views
0 votes
1 answer
0 votes
1 answer

How to unistall a file in Linux?

You can uninstall a file using the ...READ MORE

answered Mar 8, 2019 in Others by Nabarupa
773 views
0 votes
0 answers

Why can't I connect to AWS RDS?

0 I'm trying to connect to my new ...READ MORE

Mar 1 in Others by Edureka
• 13,640 points
92 views
0 votes
0 answers

Exporting a table from Amazon RDS into a CSV file

I have a MySQL database running in Amazon ...READ MORE

Mar 2 in Power BI by Edureka
• 13,640 points
270 views
0 votes
1 answer

AWS RDS Role type: Master vs Instance

AWS Identity and Access Management (IAM) is ...READ MORE

answered Mar 15 in Others by gaurav
• 13,560 points
65 views
0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10 in Others by gaurav
• 13,560 points
50 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
77 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP