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
984 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
• 22,040 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
91 views
0 votes
1 answer
0 votes
1 answer

Export a simple Dictionary into Excel file in python

You can use pandas. import pandas as pd dict1 ...READ MORE

answered Oct 23 in Others by narikkadan
• 37,660 points
122 views
0 votes
1 answer

Trying to create an enclosing bookmark after pasting a picture from Excel into Word using VBA

Try this: Sub IMPORT_TO_WORD() Dim ws1 As Worksheet, ws2 ...READ MORE

answered Oct 30 in Others by narikkadan
• 37,660 points
41 views
0 votes
1 answer

Indent table pasted from Excel into Word

It is feasible to pick up the ...READ MORE

answered Oct 30 in Others by narikkadan
• 37,660 points
44 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
158 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
383 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
• 22,040 points
138 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
• 22,040 points
313 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
208 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP