WordPress.org

Support

Error?

  • 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/

Viewing 4 replies - 1 through 4 (of 4 total)
  • 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’

    Final note: I’m running woocommerce, if your pro version supports WooCommerce migrations I’ll definitely purchase it 😉

    Plugin Author Brad Touesnard

    @bradt

    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.

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error?’ is closed to new replies.
Skip to toolbar