Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: copy data between two DBs

  1. #1
    Join Date
    Sep 2017
    Posts
    12

    Default copy data between two DBs

    I'm trying to copy data from one DB to another.

    All tables' collations are set to utf8mb4_unicode_ci (in both DBs) while the schemas are also defined this way.

    In order to insert the data into the destination table, I use "MySQL Bulk Loader" component and define the "character set" to utf8.

    Then I get the following error message "Invalid utf8 character string"

    What should I do in fix this process?

  2. #2
    Join Date
    Apr 2014
    Posts
    18

    Default

    Do not define anything for the character set.
    If I were you, I would just do export and import from MySQL Workbench.

    Quote Originally Posted by golan.manor View Post
    I'm trying to copy data from one DB to another.

    All tables' collations are set to utf8mb4_unicode_ci (in both DBs) while the schemas are also defined this way.

    In order to insert the data into the destination table, I use "MySQL Bulk Loader" component and define the "character set" to utf8.

    Then I get the following error message "Invalid utf8 character string"

    What should I do in fix this process?

  3. #3
    Join Date
    Sep 2017
    Posts
    12

    Default

    Are you referring to a manual process?

    I wish to create an auto daily process.

  4. #4
    Join Date
    Apr 2014
    Posts
    18

    Default

    From your question, I understood that you wanted to do copy from one DB to another. Dint give me impression that you wanted to do it as a daily process.
    Did you try not adding a character set in MySQL Bulk loader? And, also try different UTF encodings in select values before MySQL Bulk Loader.

    Quote Originally Posted by golan.manor View Post
    Are you referring to a manual process?

    I wish to create an auto daily process.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.