مشكلة فى زرع قاعدة بيانات كبيرة [مجابة]

[ajawad]

??? ????? ???? wampserver 2.0
-- phpMyAdmin SQL Dump
-- version 2.11.6
-- ?????? ??????: 5.0.51
-- PHP ??????: 5.2.6

-----------------------------
??? ???? ???? ????? ?? ????? ?????? ??????? ?? ???? phpmyadmin << cPanel

????????? BigDump: Staggered MySQL Dump Importer v0.29b
** ??? ??????? ??? ????? ?????? (15MB) ??? ??????? ??????

?? ????? ?? ????? ??????? ????? ??????? ??????? ( ?? ????? ???? ??? ?????? BigDump ??????? ????? ?? ??? ??? ???????+??? ????????+???? ??????+??? ????? ?????? ???? ??????? ?? ????? ??? ???? ????????)

Stopped at the line 341.

At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos.

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

??????
???? ??????? ?????? BigDump v0.29b ???? ????? ?????? ??? ??( 2M ) ????? ????? ????? ???? ?????

[Scout4all]

??? ????? ????? ???????? ???? ????????
http://www.traidnt.net/vb/showthread.php?t=12575

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

[ajawad]

???? ?? ,
?? ??????? ??? ?? ????? ??????? ????? ??? ?? ?????? ?????? ???? ?? ????? ?? ???? ??? ?? ???? ???
??? ????? ??? ?? ?????? ???????

[ajawad]

??? ????? ????? ???????? ???? ????????
http://www.traidnt.net/vb/showthread.php?t=12575

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

??? ???? ???? ????? ?? ????? ?????? ??????? ?? ???? phpmyadmin << cPanel
???? ????? ??????? ???? ???????? ( SQLSplitter.exe) - ??? ?? ???? ??????? -
???? ??????? ( 104 ???) ???? ??? ??? ???? ??????? ??????? ?? ????? ??? ???? ??????? ?????? ???

???
???????-SQL:

INSERT INTO `phpbb_forums_track` (`user_id`, `forum_id`, `mark_time`) VALUES (2, 0, 1246143218), (2, 52, 1241348296), (2, 2, 1235547092), (2, 46, 1235082808), (59, 0, 1242039606), (59, 7, 1234763503), (2, 66, 1236805617), (2, 59, 1235599691), (2, 7, 1246135574), (2, 28, 1235466248), (2, 29, 1235334783), (2, 30, 1235309418), (2, 49, 1242892066), (2, 31, 1235423947), (2, 33, 1239407288), (63, 7, 1234818252), (63, 0,

MySQL ???:

#1146 - Table 'tag_forum.phpbb_forums_track' doesn't exist

[ajawad]

*
??? ???? ?? ????? ?? ??? ????? ???????? ??? ??????? ?????? ?????? ????? ???????
???? ????????
*

[abou hayan]

??? ??? ????????
Sypex Dumper Lite 1.0.8
???????? ???? ??????? ???????? ?? ??????? ?????? ??????????
??? ?? ????? ?????? ???? ????? 240 ????? ? ???????? ???? ??? ??? ?? ??????? !!
????? ???????? ????? ???:
http://www.vbhacker.net/vb/t164155/

[ajawad]

??? ??? ????????
Sypex Dumper Lite 1.0.8
???????? ???? ??????? ???????? ?? ??????? ?????? ??????????
??? ?? ????? ?????? ???? ????? 240 ????? ? ???????? ???? ??? ??? ?? ??????? !!
????? ???????? ????? ???:
http://www.vbhacker.net/vb/t164155/

???? ??
?????? ?????? ????? ??? ??????? ????? ???? ?? ????? ????????
??? ??? ??????? ?????????? ??? ( ??????? ?????? ) ??? ???? ??? ????? ????????? ???? ?? ???? ???? ??? ??? ??? cPanel ?????? ???

[abou hayan]

???? ???? ?? ???? ???? ?????? mysql ?? ??????? ??????
-???? ??????? ????? ?? ????? ??? ???? ?? ??? : Wamp ? xampp
????? ??????? ??? ??? ???? ???? ????? ???? ???????? ??? ??? ?? ?????? ??? ????? AppServ

[ajawad]

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

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

??? ???????? ???????? ??? ( 17) ???? ?? ??? (62) ???? ?? ????? ????????

???? ?????? ?????
??? ???????: 13 mb
??? ?????: 15.75 mb
????? ???????: 62
Error found: 410 328

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

[abou hayan]

???? ????? ?????? ??? 16 ?? ??? 63 !?
???? ???? ???? ???? ????? ????? ?? ?????????
????? ????? ?? ????? ??? ?????? ???? ?? ????? ??? ???????.? ?? ???? ???????? ??? ????? ????
??? ??????? ???? ????? ????? ??? ????????

[ajawad]

*
??? ??? ???? .. ???? ???? ????? ?? ???????

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


-
??? ??? ?? ????? ??? ?????? ??? ???? ?? ????? ?? ????? ???????????
????? ????? ?? ????? ??? ?????? ???? ?? ????? ??? ???????.? .. ?? ?? ????? ?????? ?????? ???????

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

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

[abou hayan]

????? ??
???? ???? ?? ?????? ???? ?????? ( Gzip ??????? 9 ) ???? ????? ??? ????? ???????? ???? ?????? ????? ??????? ?? ?????? ?? ????? ????...
????? ???? ?? ?????? ?? ????? ????? phpbb_search* ????? ????? ???????? :
^phpbb_search*
?? ?????? ?????? ?? ???????
?????? ????? ????? ????? ???????? ?? ?????

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

[ajawad]

*
??? ???? ??? ???? ?? ?? ?? ??? ??????? ????? ??? ?????? ??????? ????? ?????? ?????.

???
???? ????? ???? ????? ?????? ??????? ?? ?????? ????? ??? ???? ?? ???? ????? ????? ????? ??? ??? ???????, ???? ???? ????? ????? ?? ??? ???????

*

[abou hayan]

???? ??? ?????? ?????? ????? ????? ?????!?
1- ?????? ???? ?? ??? ???? ???? ????????? ?? ??? ????????? ??? ??? ??? ??? ??? ?????? ?? ????? ????? ????? ???????? ????? ???????? ?????? ?????????
?????? ????? ????????? ???? ????? ovewrite ??????? ???????? ????? ????? ???? ???? ??????? ??? ?????? ?????????
2- ??? ??? ????? ?? ??? ?????? ????????? ?? ??????? ?????? ?? ??? ???????? ??????? ??? ??? ???? ????? ??? ??? ?????? ???? ???? ?????? ????? ??????

كود: تحديد الكل

CREATE TABLE IF NOT EXISTS `phpbb_search_results` (
  `search_key` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `search_time` int(11) unsigned NOT NULL DEFAULT '0',
  `search_keywords` mediumtext COLLATE utf8_bin NOT NULL,
  `search_authors` mediumtext COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`search_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `phpbb_search_wordlist` (
  `word_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `word_text` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `word_common` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `word_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`word_id`),
  UNIQUE KEY `wrd_txt` (`word_text`),
  KEY `wrd_cnt` (`word_count`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `phpbb_search_wordmatch` (
  `post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `word_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title_match` tinyint(1) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY `unq_mtch` (`word_id`,`post_id`,`title_match`),
  KEY `word_id` (`word_id`),
  KEY `post_id` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

3- ??? ??? ???? ???? ?? ???? ?? ????? ????? ????? ?????? ?????? ?? ???? ??? ?? ????? ???? ?????? ????? time out? ?? ???? ???? ????? ????? ? ????? ?? ??????? ???????
??? ?? ????? ????? ??? ???????? ?? ????? ?????? ??? ????? ?????? ??? ?????? ????? ??? ?????...

?? ????

[ajawad]

*
??????? ???? ?????? ??????
???? ???? ?? ??? ????? ???? ?? ????? ????? ??????

--
??? ???? ??? ?? ???? ??? ???? ???? ????? ????? , ???? ??? ?? ????????? ??? ???? ???? ??? ??? ???? ???? ??????? ??????? ??? ????? ?????? ???? ??? ??????? ??????? ?????? ????????

??? ?? ??? ??????? (?????? ???? ????? ?????) ??????? ??? ??????? ?????? ????? ??? ????? ????? ??? ????? ?????? ???? ???? ????.

???? ?? ???? ???? ?? ???..
*