WordPress.org

Ready to get started?Download WordPress

Forums

WP Migrate DB
Error? (5 posts)

  1. Cerilia
    Member
    Posted 9 months ago #

    Im getting this error message and its failing to import into phpmyadmn:

    SQL query:

    # WordPress MySQL database migration
    # From https://**** to https://****/newsite
    #
    # Generated: Saturday 21. September 2013 11:21 UTC
    # Hostname: localhost
    # Database: ****_****
    # --------------------------------------------------------
    # --------------------------------------------------------
    # Table: wp_commentmeta
    # --------------------------------------------------------
    #
    # Delete any existing table wp_commentmeta
    #
    DROP TABLE IF EXISTS wp_commentmeta ;

    http://wordpress.org/plugins/wp-migrate-db/

  2. Cerilia
    Member
    Posted 9 months ago #

    FYI: Exporting the existing file and then importing it via phpmyadmin gives this error message!

    Error
    SQL query:

    -- -- Dumping data for table wp_commentmeta -- INSERT INTO wp_commentmeta (meta_id, comment_id, meta_key, meta_value) VALUES (92, 86, 'is_customer_note', '0'), (104, 103, 'is_customer_note', '0'), (94, 88, 'is_customer_note', '0'), (93, 87, 'is_customer_note', '0'), (90, 84, 'is_customer_note', '0'), (89, 83, 'is_customer_note', '0'), (125, 122, 'is_customer_note', '0'), (124, 121, 'is_customer_note', '0'), (128, 125, 'is_customer_note', '0'), (109, 109, 'is_customer_note', '0'), (127, 124, 'is_customer_note', '0'), (126, 123, 'is_customer_note', '0'), (337, 345, 'is_customer_note', '0'), (117, 114, 'is_customer_note', '0'), (118, 115, 'is_customer_note', '0'), (119, 116, 'is_customer_note', '0'), (336, 344, 'is_customer_note', '0'), (121, 118, 'is_customer_note', '0'), (122, 119, 'is_customer_note', '0'), (123, 120, 'is_customer_note', '0'), (91, 85, 'is_customer_note', '0'), (108, 108, 'is_customer_note', '0'), (107, 107, 'is_customer_note', '0'), (106, 106, 'is_custom[...]

    MySQL said: Documentation

    #1062 - Duplicate entry '92' for key 'PRIMARY'

  3. Cerilia
    Member
    Posted 9 months ago #

    Final note: I'm running woocommerce, if your pro version supports WooCommerce migrations I'll definitely purchase it ;)

  4. Brad Touesnard
    Member
    Plugin Author

    Posted 9 months ago #

    I believe this is a concurrency issue. Is the site that your exporting from highly trafficked by any chance? We've already dealt with the duplicate key issue in the pro version, so if you upgraded, it would probably resolve the problem. If not, we'd work with you to get to the bottom of it and issue a refund if we can't figure it out.

  5. Cerilia
    Member
    Posted 9 months ago #

    Thank you Brad, I will indeed purchase your plugin, and hopefully with your help we can migrate my DB without too much hassle.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.