getting error during import wordpress database

  • shahid.pixxtech

    (@shahidpixxtech)


    10 years, 5 months ago

    Error
    SQL query:

    INSERT INTO qru_options (option_id, option_name, option_value, autoload) VALUES
    (336966, ‘_transient_c5_social_share_7828’, ‘a:2:{s:5:”total”;s:2:”17″;s:5:”views”;s:2:”72″;}’, ‘no’),
    (336967, ‘_transient_timeout_c5_social_share_17447’, ‘1453831677’, ‘no’),
    (336968, ‘_transient_c5_social_share_17447’, ‘a:2:{s:5:”total”;s:1:”7″;s:5:”views”;s:2:”86″;}’, ‘no’),
    (336969, ‘_transient_timeout_c5_social_share_17659’, ‘1453831716’, ‘no’),
    (336970, ‘_transient_timeout_c5_social_share_14440’, ‘1453831716’, ‘no’),
    (336971, ‘_transient_timeout_c5_social_share_13622’, ‘1453831716’, ‘no’),
    (336972, ‘_transient_c5_social_share_17659’, ‘a:2:{s:5:”total”;s:1:”4″;s:5:”views”;s:2:”74″;}’, ‘no’),
    (336973, ‘_transient_c5_social_share_14440’, ‘a:2:{s:5:”total”;s:2:”25″;s:5:”views”;s:2:”30″;}’, ‘no’),
    (336974, ‘_transient_c5_social_share_13622’, ‘a:2:{s:5:”total”;s:2:”46″;s:5:”views”;s:3:”174″;}’, ‘no’),
    (336975, ‘_transient_timeout_c5_social_share_17494’, ‘1453831756’, ‘no’),
    (336976, ‘_transient_c[…]
    MySQL said: Documentation

    #1062 – Duplicate entry ‘_transient_doing_cron’ for key ‘option_name’

Viewing 1 replies (of 1 total)
  • Eric Gunawan

    (@erricgunawan)

    10 years, 5 months ago

    Hi shahid,

    What exactly are you trying to do?

    By the SQL error warning of Duplicate entry, it seems you try to import the database twice.

    Or perhaps you try to import an sql to an existing database/tables which already had pre-existing data, hence the duplicate entry.

    If you try to restoring a database, it’s recommended if you do on a clean database/table. Or try to import it on a new database/table. Just to make sure you do not have a corrupt sql file.

Viewing 1 replies (of 1 total)

The topic ‘getting error during import wordpress database’ is closed to new replies.

Tags