Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012
    Posts
    5

    Unhappy Unanswered: select large database into local outfile

    Hi,

    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.

    Code:
    (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?

    Code:
    | connect_timeout            | 10                |
    | delayed_insert_timeout     | 300               |
    | flush_time                 | 0                 |
    | innodb_lock_wait_timeout   | 50                |
    | innodb_old_blocks_time     | 0                 |
    | innodb_rollback_on_timeout | OFF               |
    | interactive_timeout        | 28800             |
    | lc_time_names              | en_US             |
    | lock_wait_timeout          | 31536000          |
    | long_query_time            | 1.000000          |
    | net_read_timeout           | 10800             |
    | net_write_timeout          | 10800             |
    | slave_net_timeout          | 3600              |
    | slow_launch_time           | 2                 |
    | timestamp                  | 1360739003        |
    | wait_timeout               | 28800             |
    Thank you.

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Why dont you take a mysqldump of your database and bring it across.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •