XF 1.5 serious problem restoring database

[MR.MB]

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

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

    Error
SQL query:


INSERT INTO `xf_data_registry` VALUES ('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

 

[Paul B]

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

You will need to use SSH.

 

[MR.MB]

thanks brogan
can you please explain more?

 

[wang]

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.

 

[wang]

What Brogan means above, is to use another method to restore your backup. Please see this link.

http://www.wikihow.com/Use-SSH

 

[MR.MB]

What Brogan means above, is to use another method to restore your backup. Please see this link.

http://www.wikihow.com/Use-SSH

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

 

[AndyB]

In order to make a proper backup, you want to use mysqldump.

https://xenforo.com/community/resources/how-to-backup-and-restore-your-forum-linux-windows.359/

The easiest way to use mysqldump is to use cPanel and add the command to a Cron Job.

 

[MR.MB]

if i have cpanel will be easy but unfortunately ovh doesn't have cpanel

 

[TPerry]

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.

 

[MR.MB]

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

 

[wang]

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

 

[Paul B]

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

 

[MR.MB]

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

 

[wang]

Can you try some other method to restore the backup, like bigdump for example?

 

[MR.MB]

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

 

[Kintaro]

I think the best/fast/secure thing is ask some expert to make it for you.

 

[wang]

See this link please.

http://www.ozerov.de/bigdump/usage/

 

[Dakota Storm]

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

 

[MR.MB]

See this link please.

http://www.ozerov.de/bigdump/usage/

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

 

[wang]

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

I am glad to see that you were able to fix the problem.