title: HDFS to RDBMS using Sqoop - table creation
body: <p>I initially had <strong>HBase</strong> data which I exported to <strong>HDFS</strong> which generated a file named '<code>part-00000</code>'. Now, I want to export the <strong>HDFS</strong> into <strong>MYSQL</strong> using <strong>Sqoop</strong>.</p>
  
  <p>I tried to run this Sqoop command, </p>
  
  <pre><code>**$ bin/sqoop export --connect jdbc:mysql://localhost/test_db --table *bar*  --export-dir /var/hbadoop/hdfsdata/part-0000 --username root --password password -m 1**
  </code></pre>
  
  <p>It gave an error:</p>
  
  <pre><code>**Error manager.SqlManager: Error executing statement: java.sql.SQLException; Unknown intial character set index '224' received from server. Initial client character set can be forces via the 'characterEncoding' property.
        at com.mysql.jdbc.SQLError.createSQLException(SQlError.java.910)
        at com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2412)
        at ..**
  </code></pre>
  
  <p>Please note that I have <strong>not</strong> created a destination table 'bar' in MySQL to where I am planning to export HDFS data. I am not sure if I have to create a destination MYSQL table.</p>