Unanswered: select large database into local outfile
I'm using the Amazon RDS, and i would like to select all my datas in a very large table (6GB) to my local file.
Amazon does not allow "select into outfile", so i'm using both methods below.
(1) echo "select * from mytable; " | mysql -uUSER -pPASS -hHOST DB
(2) mysql -uUSER -pASS -hHOST DB -e "select * from mytable" > mytable.tsv
But my connection are cancelled very fast.
I've tried to tune the RDB making the timeout longer, but still this doesnt solve it.
I was wondering if it's because the data transfer through TCP is too large.
Anyway to solve this?
By the way, i have the same data in my own database (Not using the RDB) and i could do it very easy, so i guess it's still something to do with Amazon RDB?