Exporting a table from Amazon RDS into a CSV file

by

Presumably, you are trying to export from an Amazon RDS database via a SELECT ... INTO OUTFILE query, which yields this indeed commonly encountered issue, see e.g. export database to CSV. The respective AWS team response confirms your assumption of lacking server access preventing an export like so, and suggests an alternative approach as well via 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, like so:

mysql -u username -p --database=dbname --host=rdshostname --port=rdsport --batch
  -e "select * from yourtable"
  | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > yourlocalfilename

User fpalero provides an alternative and supposedly simpler approach, if you know and specify the fields upfront:

mysql -uroot -ppassword --database=dbtest
  -e "select concat(field1,',',field2,',',field3) FROM tabletest" > tabletest.csv

More Related Contents:

  1. Can’t connect to RDS instance from EC2 instance
  2. AWS Aurora MySQL serverless: how to connect from MySQL Workbench
  3. mysql_fetch_array() expects parameter 1 to be resource, boolean given in [closed]
  4. How to group by two rows in a column
  5. How can I output MySQL query results in CSV format?
  6. Change limit for “Mysql Row size too large”
  7. How to abort INSERT operation in MySql trigger?
  8. Converting a date in MySQL from string field
  9. Mysql or/and precedence?
  10. Ordering by specific field value first
  11. CHECK constraint in MySQL is not working
  12. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  13. Which is more efficient: Multiple MySQL tables or one large table?
  14. Are there disadvantages to using a generic varchar(255) for all text-based fields?
  15. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  16. MySQL InnoDB foreign key between different databases
  17. storing money amounts in mysql
  18. MySQL CREATE FUNCTION Syntax
  19. Difference between two table structure
  20. MySQL sum elements of a column
  21. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  22. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  23. How to store decimal in MySQL?
  24. When to use a left outer join?
  25. MySQL cumulative sum grouped by date
  26. CREATE command denied to user？
  27. What is the MAX number if I store int(255) in MySQL?
  28. How to initialize mysql container when created on Kubernetes?
  29. Find duplicates in the same table in MySQL
  30. Auto-increment is not resetting in MySQL

Leave a Comment