title: How to copy csv data file to Amazon RedShift?
body: <p>I'm trying to migrating some MySQL tables to Amazon Redshift, but met some problems.</p>
  
  <p>The steps are simple:
  1. Dump the MySQL table to a csv file
  2. Upload the csv file to S3
  3. Copy the data file to RedShift</p>
  
  <p>Error occurs in step 3:</p>
  
  <p>The SQL command is:</p>
  
  <blockquote>
    <p>copy TABLE_A from 's3://ciphor/TABLE_A.csv' CREDENTIALS
    'aws_access_key_id=xxxx;aws_secret_access_key=xxxx' delimiter ',' csv;</p>
  </blockquote>
  
  <p>The error info:</p>
  
  <blockquote>
    <p>An error occurred when executing the SQL command: copy TABLE_A from
    's3://ciphor/TABLE_A.csv' CREDENTIALS
    'aws_access_key_id=xxxx;aws_secret_access_key=xxxx ERROR: COPY CSV is
    not supported [SQL State=0A000]  Execution time: 0.53s 1 statement(s)
    failed.</p>
  </blockquote>
  
  <p>I don't know if there's any limitations on the format of the csv file, say the delimiters and quotes, I cannot find it in documents.</p>
  
  <p>Any one can help?</p>