Amazon RDS kann "SELECT ... INTO OUTFILE" nicht verwenden.
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.
https://forums.aws.amazon.com/thread.jspa?threadID=41443
Mit mysqldump_to_csv.py konnte ich in CSV ausgeben.
Befehlsinstallation
$ wget https://raw.githubusercontent.com/jamesmishra/mysqldump-to-csv/master/mysqldump_to_csv.py
CSV-Ausgabe
$ mysqldump -u username -p --host=rdshostname database table | python mysqldump_to_csv.py > table.csv
Exporting table from Amazon RDS into a csv file
Recommended Posts