1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 serious problem restoring database

Discussion in 'Troubleshooting and Problems' started by MR.MB, Dec 4, 2015.

  1. MR.MB

    MR.MB Member

    Hi,

    i get problem with my website and im trying to restore my database i receive backup from ovh.com and im trying to import to my phpmyadmin page i splint the file backup to 6 parts
    2015-12-04_21-33-33.png
    but the second part i get this error please i need to figure out this problem or i will lose my website please i need help please someone help me

    this is the error i get
    2015-12-04_21-39-48.png

    PHP:
        Error
    SQL query
    :


    INSERT INTO `xf_data_registryVALUES ('BRASS_rebuildTemplate','b:0;'),('addOns','a:34:{s:23:\"AVForums_AutoLinkTitles\";i:1000970;s:17:\"BLProfileVisitors\";i:1;s:10:\"BestAnswer\";i:20;s:17:\"*******ThreadIcon\";i:1030000;s:22:\"*******_HideAttachment\";i:1020600;s:24:\"*******_ResourceDownload\";i:1000000;s:5:\"CtaFt\";i:2160070;s:6:\"DevKit\";i:1;s:23:\"Hide_contents_of_bbcode\";i:1;s:6:\"ITD_AI\";i:1350;s:10:\"MoreThread\";i:1000100;s:18:\"OnlineStatusRibbon\";i:145;s:10:\"PostRating\";i:33;s:19:\"Reversed_words_xFAr\";i:1428513707;s:14:\"SSD_threadinfo\";i:1002;s:15:\"UnreadPostCount\";i:1020070;s:23:\"Waindigo_LastPostAvatar\";i:1373139139;s:12:\"WaterMarkAdd\";i:3;s:12:\"WeeklyDigest\";i:1;s:19:\"XPRenameAttachments\";i:1;s:7:\"XenCore\";i:2;s:11:\"XenResource\";i:1020170;s:13:\"adctaftwidget\";i:1000171;s:23:\"keywords_xenForo_arabic\";i:0;s:17:\"kl_password_tools\";i:8;s:12:\"liam_allrich\";i:10100;s:18:\"nobita_AvatarAlive\";i:10000710;s:23:\"nobita_ThreadtoResource\";i:7;s:[...]



    MySQL said: Documentation

    #1062 - Duplicate entry '
    addOns' for key 'PRIMARY
    please help urgent :(
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    You're unlikely to get a good result using phpMyadmin.

    You will need to use SSH.
     
    MR.MB likes this.
  3. MR.MB

    MR.MB Member

    thanks brogan
    can you please explain more?
     
  4. wang

    wang Well-Known Member

    I think this is caused from an add on. Because I see many names mentioned there that are not part of xenforo. Can you delete the addOns field from the xf_data_registry? Because it looks like it is already in the database, and when you try to restore the backup copy, it tries to add it again. And that is why is spitting out that error.
     
    MR.MB likes this.
  5. wang

    wang Well-Known Member

    MR.MB likes this.
  6. MR.MB

    MR.MB Member

    absolutely cant do that, hard for me..
    i will call ovh tomorrow for restarting database with paid request
    thanks guys, appreciate that
     
  7. AndyB

    AndyB Well-Known Member

  8. MR.MB

    MR.MB Member

    if i have cpanel will be easy but unfortunately ovh doesn't have cpanel
     
  9. Tracy Perry

    Tracy Perry Well-Known Member

    Are you familiar with setting up a new user and giving them sudo priv's? If so, start a convo with me and I can either import your full one into the DB or export - not sure what exactly you are needing.
     
  10. MR.MB

    MR.MB Member

    good morning,
    i call today ovh and they said we cant restore your database, they can only give me restore file and i import in phpmyadmin nothing more.
    i think i need help with someone here
     
  11. wang

    wang Well-Known Member

    Why were you splitting up the backup file in 6 seperate parts?
     
  12. Brogan

    Brogan XenForo Moderator Staff Member

    I suspect because it's over the limit for phpMyAdmin.
     
  13. MR.MB

    MR.MB Member

    phpmyadmin cant accept file more than 16 mo
    otherwise i try 2mo part and 10mo part
    same problem
     
  14. wang

    wang Well-Known Member

    Can you try some other method to restore the backup, like bigdump for example?
     
    MR.MB likes this.
  15. MR.MB

    MR.MB Member

    method bigdump its hard for me, as you see im not expert
    if there is specific and easy explanation for that maybe i can use
     
  16. Kintaro

    Kintaro Well-Known Member

    I think the best/fast/secure thing is ask some expert to make it for you.
     
    MR.MB likes this.
  17. wang

    wang Well-Known Member

    StarArmy and MR.MB like this.
  18. Dakota Storm

    Dakota Storm Well-Known Member

    Do yourself a favor and contact @Tracy Perry, he's already offered to help.
     
  19. MR.MB

    MR.MB Member

    bingooo the problem resolved by this link
    thank you my friend you saved me. big thanks to you and to all who help me here. thanks xenforo.com
     
    StarArmy and wang like this.
  20. wang

    wang Well-Known Member

    I am glad to see that you were able to fix the problem.
     
    MR.MB likes this.

Share This Page