حل مشكلة جداول البحث عند نقل قاعدة البيانات

[الطالب12]

?????? ????? ????? ???? ???????

??? ????? ???? ??? ????? ???? ???? ??? ?? ????? ????? ?? ????? ????? ??????? ??? ????? ????? ???????? ????? ????? ???? ??????? ?? ?????? ??? ???. ???? ??? ????????? ????? ??????? ???? ??????? ??????? ???? ??????? ????? ??? ?? ????? ??? ??? ?? ????? ?? ?? ????? ?? ????? ?????.

???? ???? ???? ????? ??? ?? ??????? ????? ???????? BigDump ????? ??? ????? ???????? ????????? ????? ???? ?????? ?? ?????? ??? ???. ????? ?????? ?? ??? ??????? ????? ????? ?? ????? ???? ??? ??????? ?????? ????? ??? ??????? ????? ?????? , ????? ???????:

http://www.phpbbarabia.com/viewtopic.php?t=17894


??????? ?????? ????? ????? ???? ??????

1) ??????? ?? ????? ????? ???? ?????? ???? ????? ????????. ???? ????.
2) ??? ???? ??? ???? ???? ????? ??? ????? ????? ????????.
3) ???????? ??????? ?????? ????? ???????? ??? ????? ?????? ??? ????? ??? ?????.


????? ??? ??????? dump.php ?????? ?? ??????? ?????? ???? ???? ?? ????? ?? ????? ????? ????? ???? ??? ?? ???? ?? ????? ????? ??????? , ???? ??????? ????? ?? ????? ??? ???? ?????? ?????? ???? ???? ???? ???

Error at the line 000000: INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('aaa', '000', '0');

Query: INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('bbb', '000', '00');

MySQL: Duplicate entry 'ccc' for key 1

??? ?????? ??????? aaa, bbb, ccc ???? ??? ????? , ???????? 000 ??? ?????? ???? ??? ????? ????? ?? ??? ??? ???.

???? ??? ??? ????? ??? ??? ???? ??? ?? ????? ?? ???? auto_increment ?? ??? ?????? ???? ???????? ?? ?? ?????? ????? ????? ??????? ??????? ?????? ?????? ?? ????? ???????? ??? ????? ????? ????????? ??? ????? ??? ??? ??????? ??? ???? ???? ????? ???? ?? ???? ?? ???? ???? ??? ??? ????? ?????.

??? ??? ?? ?????? ?? ???? ????? ??? ????? INSERT INTO ??? ????? ???? ??? ???????

????? ?????: ??? ?????? ???? ??? ??? ????? ??? ??? ?????? phpbb_search_wordlist ??? ????? ????? ??????? ????? ?????? ???? ?? ?????? ??? ?? ??? ????? ?????????., ?? ??? ??????? ??????? ?????? ??? ???? ??? ????? ?? ???? ???. ?? ??? ???? ?? ????? ????? ?? ???? ??? ??????? ????? ???????? ??? ??? ??? ???????.
??? ??? ??????? ??? ??? ????? ???????? ????? ???? ???? ????? ????? ?????? ?????? ????? ???? ????? ??? ?? ????? ????? ?????? ?????. ???? ???????? ???? ???????? ???? ???? ???? ??? ?????

??? ???? ???? ???? EditPad Pro ?????? ?? ??? ??????? ??????? ??? ???? ?????? ???? ????? ?? ??????? ??? ????? ???? ?? ???? ????? ??????? ????? ???? ?? ?????? ???? ?????? ??? ????? 30 ??? ????????? ?? ????? ????? ????????.????? ?? ???
http://www.editpadpro.com

???? ????? ?????? ???? ?????? ????? ?? ???????? ???? EditPad Lite ???? ??? ?????? ?????? ???? ???? ?????? ??????? ????? ???? ??? ??? ??? ?????? ?????????? ?? ????? ??????? ???? ???? ???. ???? ??????? ??? ??? ?????? ???????? ?? ???
http://www.editpadpro.com/editpadlite.html

???? ????? ???????? ????????? ?????? ???? ????? ?? ??????? ??????? ?????? ??????

phpbb_search_results
phpbb_search_wordlist
phpbb_search_wordmatch

???? ?? ??????? phpbb ?? ????? ??????? ?? ???? ?????? ??? ???? ??? ???????? ????? ????? ?????? ??? ??? ?????? ????.

????? ????? ????? ??? ???? ??????? ???? XXXX. ?? ????? ??? ?????? ?? ?????? ?????????? ???? ???????? ???????:

--
-- Table structure for table `XXXX`
--
?? ???????? ???????
#
# Table Data for phpbb_attach_quota
#
?? ??? ???? ?? ??? ???? ??? ?? ??? ??? ???????? ???? ???? ?? ????? ???????? phpMyAdmin ?? ???? ???? ???????

?? ???? ?????? ?? ????? ??????? ?????? ?? ??? ?? ??? ??? ????? ??????? ?????? ??????? ???? ???? ?????? ????? ??? ??????. ???? ???? ?? ???? ?????? XXXX ?????.

????? ?????? : ??? ??? ??? ?? ???? ????? ????? ??????? ????? ?????? ??? ?????? ?????????? ????? ?? ????? INSERT ?? ???? ?? ????? ????? ??????? ?????. ????? ??? ?? ????? ?? ?????? ?????? ?????? ?? INSERT ?? XXXX ??? ????? ?????? ?? ???? ????? ??????? ??????? ?????. ?? ???? ?? ??? ???? ???????? ???????
INSERT INTO XXXX

???? ????? ????? ??????? ????? ?????? ?????? ????? ?? ???? ???? ???? ???????? ???????

INSERT INTO phpbb_search_results
INSERT INTO phpbb_search_wordlist
INSERT INTO phpbb_search_wordmatch

???? ??????? ???? ?? ????? ?????? ?? ????? INSERT ???? ?????? ???.

????? ???: ?? ???? ??? ??? ??? ??? ??? ????? ???? ?? ????? ??????? ???? ????? ????? ????? ???? ????? ????? ???? ?????? ????? ?????????. ???? ???? ???? ???? ??? ?? ?????? ???? ?? ???? ??? ?? ???? ?? ??????.

??? ???? ??? ??? ?? ????? ????? ?? ?????? ?? ??????? ???????? ?? ?? INSERT ??? ????? ????, ?? ?? ???? ?? ??????? ????? ??????? ??? ????? ?????? ???? ??? ??? ????? ??????? ??????? ?? ????? ?????? ????? ????? ????? ??????? rebuild_search . ??? ????? ????? ?????? ????? ????? ???? ?????? ??? ?? ???? ?????? ????? ?????? ????? ???? ??? ???? ??? ???????. ??? ??? ???? ???? ????? ????? ???? ?? ??????.

???? ???? ??? ??? ????? ????? ?? ????? ??????? ??? ??? ????? ????? ??????? ????????, ???? ???? ??? ??????? phpMyAdmin ?????? ???? ??? Export ???? ?????? ???? ???? ?? ???? ??? ??????? ???? ?????? ???? ????? ????? ?????? ????? ??? ????? ?? ????? ??? ????? , ?? ???????? ???????? ????? ???? ????? ????? ?? ????? ????? ????????.

???? ?????? ???? ???? ????? , ???? ???????? ?? ??? ???? ?? ????? ????? rebuild_search ????? ?????? ????? ????? ??? ??????. ??? ??????? ????? ??????? ???? ???? ????? ?? ????? ????? ?????? ????? ?????? ?????????? ????? ???? ?? ??? ???? ?? ????? ?? ????? ????? ???? ???????? ????? ?? ????? ????? ????.


???? ?????:
?? ???? ?? ???? ????? ??????? ????? ????? rebuild_search ??? ??? phpbb ??????
??? ????? ????? ???? ??? ??? 2.0.10 ???? ?? ?????? ?? ???? ??????? ????????.

?? ???? ????? ???? ?? ???? ??????? ???? ?? ?????
??? ????? ???? ??? ????? ????? ??? ????? ?????? ?????? ????? ??? ??????? ?? ????? ?????? ?? ??? ????? ??? ????? ????? ????? ???? ??? ????? ????? ??? ????? ??????.

?? ???? ????? ?? ????? ???????? ????? ????? ????? ?
??? ????? ????? ????? ?? ????? ?? ????? ???? ???? ??? ??? ??????? ????? ?? ???? ?? ???? ??? ???? ???? ???? ?? ??? ?? ????? ??? ???? ???? ???????? ?? ??????? ???? ????? ??? ??? ????? ???? ???? ?????? ???? ???? ????? , ????? ?????? , ??? ??????? ??????? ?? ??? ????????? ????????. ???? 600 ??? ?????? ???? ??? ???? ??????? ? ????? ? 200 ??? ?????? ?????? ???? ?? 20 ??? ????? ??????? ?? ?????? ??????. ????? ?????? ????? ??????? ??? ????? ????? ????? ?????? 5 ?? 10 ????? ????.

???? ?? ?? ?????? ??? ????? ????? ????? ?
?? ?? ?? ????? ?? ??????? ???? ????? ?? ??? ?????? ??? ???? ?????? , ???? ??? ?????? ?? ??????? ?????? ?? ????? ???????? ??????? ?????? ??????.

??? ????

[saanina]

??????12,

????? ???? ?????? ??????? ?????????

???? ?????? ?? ???? ???? ??????? editpad ??? notepad++ ???? ???? ???? ????? ????? ?? ??? ????? ..

???? ????? ??????? ?????? ???? ??????? ????? .. ??? ?????? ???? ??????? .. ??? .


?????

[الامبراطور]

????? ????? ?? ??? ???? ??????
???? ????? ???????

???? ???? ???

[andar]

??? ???? ?? ?? ??? ?????? ??? INSERT INTO ????? ???? ?????? ????? ????? 3 ????

????? ???? ?? ??? ???? ????? ???? ????

[usamaX]

????? ??????? ??? ???????..