title: How to copy csv file from s3 to mysql rds
body: <p>I had written a code in python connecting to rds(Mysql),the connection was sucessfull but when iam trying to copy a csv file from s3 its not working</p>
  
  <pre><code># Begin your transaction
  cur.execute("begin;")
  cur.execute("copy public.a from 's3://XXXXXXX/a.csv' credentials 'aws_access_key_id=XXXXXXXXx ;aws_secret_access_key=XXXXXXXXX' csv;")
  # Commit your transaction
  cur.execute("commit;")
  print("Copy executed fine!")
  </code></pre>
  
  <p>I am not getting any error. I can connect to rds and create a table in that but I can't load that data from s3 </p>
  
  <pre><code>import mysql.connector 
  
  REGION = 'us-east-1' 
  rds_host = "XXXX" 
  name = "xxxx" 
  password = "XXXX" 
  db_name = "XXX" 
  
  def mysql_connector(): 
      conn = mysql.connector.connect(user='XXXX', password='XXXX', host='XXXX', port= 3306, database='XXXX', use_unicode=True)
      cur = conn.cursor()
      cur.execute( "create table a(_c0 varchar(20),_c1 varchar(20),_c2 varchar(30),_c3 varchar(30),_c4 varchar(30),_c5 varchar(30),value varchar(30),status varchar(20));")
  </code></pre>
  
  <p>After this I begin transaction from s3 to rds but I can't commit my transaction. </p>