|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
Hi there! I'm currently moving my site away from shared hosting to a VPS and over the past week i've been rehearsing the move everything has gone okay, until i actually do the move for real today that is . Each time i've imported the sqldump previously using phpmyadmin things have completed successfully, today however i'm repeatedly getting an #1062 - Duplicate entry in the 'Word' table error. I've tried: AdminCP->Maintenance->Repair/Optimise Tables AdminCP->Maintenance->Repair/Optimise Tables->Fix Unique Indexes AdminCP->Maintenance->Update Counters->Rebuild Search Index ...and dropping the entire db on the new server and re-exporting and importing after each of those steps, but still getting the same error I managed eventually to get the db to import successfully eventually by editing the sqldump line that was 'alledgedly' duplicated although i could only find one instance of it in the dump from: Code: INSERT INTO `word` VALUES (11971, 'you’re'); to Code: REPLACE INTO `word` VALUES (11971, 'you’re'); Trouble is i'm not very experienced and i'm not sure what i've done, have i fixed it or made things worse ? Have i damaged the imported db in any way? I also noticed that the 'Cardinality' (whatever that is) is one less for the keys in that table in the imported db that the Exported db. Sorry for the long winded post. __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Forum Error Number : 1062 Duplicate entry 'blog_comment--10-template' for key 2 | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 06-21-2010 04:40 PM |
Forum ERROR 1062 (23000) at line 7632: Duplicate entry 'crüe' for key 2 | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-04-2010 10:00 PM |
#1062 - Duplicate entry '2029' for key 1 | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 02-15-2010 04:10 AM |
ERROR 1062 (23000) at line 247925: Duplicate entry 'mobile?' for key 2 | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-29-2009 01:10 PM |
ERROR 1062 (23000) at line 40: Duplicate entry 'ג[�¢��¨�]' for key | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 06-20-2009 07:10 PM |