Amazon RDS ne peut pas utiliser 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.
https://forums.aws.amazon.com/thread.jspa?threadID=41443
En utilisant mysqldump_to_csv.py, j'ai pu sortir en CSV.
Installation de commande
$ wget https://raw.githubusercontent.com/jamesmishra/mysqldump-to-csv/master/mysqldump_to_csv.py
Sortie 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
Recommended Posts