Not able to create a table from Oracle on AWS to Mysql on AWS machine.

  • nadeemj_20866
    Participant
    5 years, 7 months ago #5429

    hi, I need to copy a new table from Oracle to Mysql and after that i need that table to be synching after every 5 minutes. I have been doing this for more than 2 years. This time our Mysql db in AWS ubuntu server and when I try to run the DBSync program, it gives me error everytime. The error info is below.

    Connecting to the source database.
    Connecting to the destination database.
    Creating history store for bitnami_wordpress
    — Error 1071: Specified key was too long; max key length is 255 bytes
    Closing connections.
    Process failed.
    Total time elapsed – 00:00:02

    Any idea or suggestion would be appreciated.

    sridhara.r_20153
    Participant
    5 years, 7 months ago #5691

    Hi Nadeem,

    Please share your dbsync username .

    Note: you have posted on http://www.mydbsync.com community

    nadeemj_20866
    Participant
    5 years, 7 months ago #5692

    License Information:
    Name: Robert Clasen
    Company:
    E-mail: bclasen@ait-inc.com

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.