[YaGMuR_PreNSi]

Merhabalar sitemin hostunu değiştirdim SQL yedeğini navicattan almıştım ve yeni serverdeki db ye geri yüklerken hata veriyor ve yükleyemiyorum navicattan yedeği .SQL olarak çevirttiriyorum onu yüklerkende bir sürü hata veriyor.. 4 tane yedeği denedim hepsini ayı yaptı işte hata:

Duplicate entry 'options' for key 1


bunu nasıl çözebilrim ...
Lütfen yardımcı oLun..

[Scud]

hata(error) değil de uyarı (warning) olabilir mi?

söylediği şey sözkonusu tabloda benzersiz (unique) anahtarların bulunduğu sütunda iki tane birbirinin aynı değerde kayıt var.

[YaGMuR_PreNSi]

MySQL Front ile verdiği hata:

Duplicate entry 'options' for key 1 (1062)  -  INSERT INTO `datastore` VALUES ('attachmentcache','a:11:{s:3:\"bmp\";a:5:{s:4:\"size\";s:5:\"20000\";s:5:\"width\";s:3:\"620\";s:6:\"height\";s:3:\"280\";s:9:\"thumbnail\";s:1:\"0\";s:9:\"newwindow\";s:1:\"0\";}s:3:\"doc\";a:5:{s:4:\"size\";s:5:\"20000\";s:5:\"width\";s:1:\"0\";s:6:\"height\";s:1:\"0\";s:9:\"thumbnail\";s:1:\"0\";s:9:\"newwindow\";s:1:\"0\";}s:3:\"gif\";a:5:{s:4:\"size\";s:5:\"20000\";s:5:\"width\";s:3:\"620\";s:6:\"height\";s:3:\"280\";s:9:\"thumbnail\";s:1:\"1\";s:9:\"newwindow\";s:1:\"0\";}s:3:\"jpe\";a:5:{s:4:\"size\";s:5:\"20000\";s:5:\"width\";s:3:\"620\";s:6:\"height\";s:3:\"280\";s:9:\"thumbnail\";s:1:\"1\";s:9:\"newwindow\";s:1:\"0\";}s:4:\"jpeg\";a:5:{s:4:\"size\";s:5:\"20000\";s:5:\"width\";s:3:\"620\";s:6:\"height\";s:3:\"280\";s:9:\"thumbnail\";s:1:\"1\";s:9:\"newwindow\";s:1:\"0\";}s:3:\"jpg\";a:5:{s:4:\"size\";s:6:\"100000\";s:5:\"width\";s:1:\"0\";s:6:\"height\";s:1:\"0\";s:9:\"thumbnail\";s:1:\"1\";s:9:\"newwindow\";s:1:\"0\";}s:3:\"pdf\";a:5:{s:4:\"size\";s:5:\"20000\";s:5:\"width\";s:1:\"0\";s:6:\"height\";s:1:\"0\";s:9:\"thumbnail\";s:1:\"1\";s:9:\"newwindow\";s:1:\"0\";}s:3:\"png\";a:5:{s:4:\"size\";s:5:\"20000\";s:5:\"width\";s:3:\"620\";s:6:\"height\";s:3:\"280\";s:9:\"thumbnail\";s:1:\"1\";s:9:\"newwindow\";s:1:\"0\";}s:3:\"psd\";a:5:{s:4:\"size\";s:5:\"20000\";s:5:\"width\";s:1:\"0\";s:6:\"height\";s:1:\"0\";s:9:\"thumbnail\";s:1:\"1\";s:9:\"newwindow\";s:1:\"0\";}s:3:\"txt\";a:5:{s:4:\"size\";s:5:\"20000\";s:5:\"width\";s:1:\"0\";s:6:\"height\";s:1:\"0\";s:9:\"thumbnail\";s:1:\"0\";s:9:\"newwindow\";s:1:\"0\";}s:3:\"zip\";a:5:{s:4:\"size\";s:6:\"100000\";s:5:\"width\";s:1:\"0\";s:6:\"height\";s:1:\"0\";s:9:\"thumbnail\";s:1:\"0\";s:9:\"newwindow\";s:1:\"0\";}}','1'),  ('products','a:15:{s:8:\"_vbshout\";s:1:\"1\";s:12:\"cyb_topstats\";s:1:\"1\";s:11:\"post_thanks\";s:1:\"1\";s:11:\"moodmanager\";s:1:\"1\";s:7:\"Cyb_SFA\";s:1:\"1\";s:13:\"catagoryicons\";s:1:\"1\";s:9:\"memberbot\";s:1:\"1\";s:21:\"nicks_homeannoncement\";s:1:\"1\";s:18:\"ncode_imageresizer\";s:1:\"1\";s:7:\"c_ct_v1\";s:1:\"1\";s:13:\"latestthreads\";s:1:\"1\";s:14:\"paulm_20050610\";s:1:\"1\";s:10:\"devel_poll\";s:1:\"1\";s:8:\"vbhspeed\";s:1:\"1\";s:9:\"Vbulletin\";s:1:\"1\";}','1'),  ('languagecache','a:2:{i:1;a:3:{s:10:\"languageid\";s:1:\"1\";s:5:\"title\";s:12:\"English (US)\";s:10:\"userselect\";s:1:\"0\";}i:11;a:3:{s:10:\"languageid\";s:2:\"11\";s:5:\"title\";s:6:\"Türkce\";s:10:\"userselect\";s:1:\"1\";}}','1'),  ('stylecache','a:1:{i:-1;a:1:{i:1;a:1:{i:0;a:5:{s:7:\"styleid\";s:2:\"24\";s:5:\"title\";s:10:\"Premium V3\";s:8:\"parentid\";s:2:\"-1\";s:12:\"displayorder\";s:1:\"1\";s:10:\"userselect\";s:1:\"1\";}}}}','1'),  ('options','a:430:{s:15:\"templateversion\";s:5:\"3.6.8\";s:19:\"subscriptionmethods\";i:0;s:10:\"attachfile\";s:0:\"\";s:10:\"attachpath\";s:34:\"/path/to/your/attachment/directory\";s:13:\"usefileavatar\";i:0;s:10:\"avatarpath\";s:15:\"./customavatars\";s:9:\"avatarurl\";s:13:\"customavatars\";s:14:\"profilepicpath\";s:19:\"./customprofilepics\";s:13:\"profilepicurl\";s:17:\"customprofilepics\";s:10:\"sigpicpath\";s:15:\"./signaturepics\";s:9:\"sigpicurl\";s:13:\"signaturepics\";s:14:\"fulltextsearch\";i:1;s:8:\"bbactive\";i:1;s:14:\"bbclosedreason\";s:46:\"<p>Yapım Aşamasındayız</p>\";s:13:\"cybsfa_enable\";s:1:\"1\";s:7:\"bbtitle\";s:44:\"MasterBahis-Türkiye\'nin En Yeni Bahis Forumu\";s:5:\"bburl\";s:33:\"http://www.masterbahis.com/forum/\";s:9:\"hometitle\";s:15:\"MasterBahis.Com\";s:7:\"homeurl\";s:33:\"http://www.masterbahis.com/forum/\";s:13:\"contactuslink\";s:15:\"sendmessage.PHP\";s:13:\"contactustype\";i:1;s:16:\"contactusoptions\";s:35:\"site Feedback\r\nRegistration Problem\";s:14:\"webmasteremail\";s:25:\"webmaster@masterbahis.com\";s:10:\"privacyurl\";s:0:\"\";s:13:\"copyrighttext\";s:0:\"\";s:11:\"companyname\";s:0:\"\";s:9:\"faxnumber\";s:0:\"\";s:7:\"address\";s:0:\"\";s:8:\"keywords\";s:68:\"\'\'bahis,iddaa,futbol,basketbol,bet,ligtv,canlımaç,sopcast,p2p\'\'\";s:11:\"description\";s:31:\"Bahis Hakkında Herşey\";s:12:\"useforumjump\";i:1;s:12:\"pagenavpages\";i:3;s:8:\"pagenavs\";s:18:\"10 50 100 500 1000\";s:12:\"enableaccess\";i:1;s:15:\"addtemplatename\";i:0;s:15:\"usestrikesystem\";i:1;s:12:\"forumleaders\";i:1;s:16:\"allowedreferrers\";s:0:\"\";s:13:\"threadmarking\";s:1:\"0\";s:12:\"markinglimit\";i:10;s:12:\"disable_ajax\";i:0;s:9:\"imagetype\";s:2:\"GD\";s:12:\"regimagetype\";s:5:\"GDttf\";s:14:\"regimageoption\";i:15;s:10:\"magickpath\";s:0:\"\";s:8:\"yestoday\";i:1;s:10:\"timeoffset\";i:2;s:8:\"dstonoff\";i:1;s:10:\"dateformat\";s:5:\"d-m-Y\";s:10:\"timeformat\";s:3:\"H:i\";s:20:\"registereddateformat\";s:3:\"F Y\";s:10:\"calformat1\";s:5:\"j F Y\";s:10:\"calformat2\";s:3:\"j F\";s:13:\"logdateformat\";s:11:\"H:i, jS M Y\";s:13:\"cookietimeout\";i:21600;s:10:\"cookiepath\";s:1:\"/\";s:12:\"cookiedomain\";s:0:\"\";s:10:\"gzipoutput\";i:1;s:9:\"gziplevel\";i:1;s:10:\"addheaders\";i:0;s:14:\"nocacheheaders\";i:0;s:17:\"useheaderredirect\";i:1;s:12:\"allowphpinfo\";i:0;s:11:\"cachemaxage\";i:7;s:15:\"threadviewslive\";i:0;s:19:\":zuha:\";s:0:

[Scud]

veritabanndaki tüm tabloları silip
şu şekilde yüklemeyi dener misin

1) msdos aç (ya da linux konsolu)

2) SQL dosyanın bulunduğu klasöre git (cd c:\klasor\altklasor)

3) aşağıdaki komutu çalıştır


MySQL -h localhost -u dbkullanıcı -p veritabanıadı < yedek.SQL

[YaGMuR_PreNSi]

Hocam size çok çok teşekkür ederim sorunsuz aktardı. İlginiz için teşekkür ederim.