More than 5 years have passed since last update.

AmazonRDSのテーブルをCSV形式でエキスポートする

Python
RDS

Last updated at 2015-07-07Posted at 2015-07-07

問題

Amazon RDSは、SELECT ... INTO OUTFILEが使えない。

The "SELECT ... INTO OUTFILE" command creates a file on the database server.  MySQL does not provide a way to use this command to create a file on the client.

解決

mysqldump_to_csv.pyを使うことで、CSVで出力ができた。

コマンドのインストール

$ wget https://raw.githubusercontent.com/jamesmishra/mysqldump-to-csv/master/mysqldump_to_csv.py

CSVの出力

$ mysqldump -u username -p --host=rdshostname database table | python mysqldump_to_csv.py > table.csv

転載元

Exporting table from Amazon RDS into a csv file

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up