title: How can I upload the table data from local database to cloud service?
body: <p>I want to upload the database from local to cloud services like aws.
  I have successfully created the database and tables and columns in cloud database from local database, but not able to transfer the data.</p>
  
  <p>I have tried using outfile and infile command using python but getting an error</p>
  
  <pre class="lang-py prettyprint-override"><code>mycursor3.execute("SELECT * FROM %s INTO OUTFILE '/var/lib/mysql-files/test.csv' "% (tb[0]))
  sqlformula="LOAD DATA LOCAL INFILE 'test.csv' INTO TABLE %s "% (tb[0])
  mycursor1.execute(sqlformula)
  mydb1.commit()
  </code></pre>
  
  <p>File is exported successfully but is unable to import in cloud.
  Getting an error :mysql.connector.errors.InterfaceError: File 'test.csv' could not be read</p>