¥Ñ©ó¤@¨Ç¤j¼Æ¾Ú®w¶W¥X¤F php ¤º¤W¶Çªº­­¨î¦Ó¾É­P¤£¯à¶×¤J, ¨Ï¥Î¤U php ÀÉ«K·|¦Û¦æ¥N¬°¤À¬q¶×¤J

¨Ï¥Î¿ìªk (¦¹´ú¸Õ¬O¨Ï¥Î phpmyadmin ³Æ¥÷ªº¼Æ¾Ú) :
1. ¥ý¤U¸ü bigdump.zip ¸ÑÀ£«á©ñ¦b discuz ®Ú¥Ø¿ý¤W
¤U¸ü BigDump ³Ì·sª©¥»
°Ñ¦Òºô§} http://www.ozerov.de/bigdump.php

2. ±N¼Æ¾ÚÀÉ®× («á§Ç¬° sql ªº³Æ¥÷ÀÉ®×) ¤W¶Ç¨ì discuz ®Ú¥Ø¿ý¤W

3. ¥Î°O¨Æ若¶} bigdump.php, §ä¤Î¶ñ¤W¤U¦C¤º®e


4. °õ¦æ bigdump.php (§Y¦bºô§}Äæ¿é¤J http://ºô§}/bigdump.php)
«K·|Åã¥Ü¦p¤U
Start Import from ¼Æ¾ÚÀÉ®× into ¼Æ¾Ú®w¦WºÙ at localhost
«ö Start Import «K¶}©l¶i¦æ¶×¤J¤Î¦Û°Ê§¹¦¨, ½Ð­@¤ßµ¥­Ô

5. §¹¦¨«á«K·|Åã¥Ü¦p¤U

6. §R°£ bigdump.php ¤Î¼Æ¾ÚÀÉ®×

§¹¦¨

POKA¯à¤£¯à¦b¼g²M·¡ÂI

ÁÙ¦³¤°»ò°ÝÃD¦s¦b?

BigDump: Staggered MySQL Dump Importer ver. 0.21b
Processing file: happyst_bbs.sql

Starting at the line: 1

Error at the line 27: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Query: CREATE TABLE `cdb_access` ( `uid` mediumint(8) unsigned NOT NULL default '0', `fid` smallint(6) unsigned NOT NULL default '0', `allowview` tinyint(1) NOT NULL default '0', `allowpost` tinyint(1) NOT NULL default '0', `allowreply` tinyint(1) NOT NULL default '0', `allowgetattach` tinyint(1) NOT NULL default '0', PRIMARY KEY (`uid`,`fid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

MySQL: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 9

Stopped on error

Start from the beginning (DROP the old tables before restarting)

© 2003-2005 Alexey Ozerov - BigDump Home

$filename        = "";          ¡ö¶ñ¤W¤w¤W¸üªº¼Æ¾ÚÀɮצWºÙ
«Y¶ñ­Ó¦W?
(xxx)
©w«Y¦¨­Ó?
(xxx.sql)

¡ö¶ñ¤W¤w¤W¸üªº¼Æ¾ÚÀɮצWºÙ
§Y«Y­n«Yphpmyadmin­Ósql¤W¸ü¥ª¥ý???
¤§«á¥ý¶ñ³oùØ???????????
¦ý§Ú3mb¤W¸ü­ø¨ìØ{

³o¶KÀ³¸Ó¸m³»§a......

1. ¬O¾ã­Ó xxx.sql ¤W¸ü
2. ¥Î ftp ¬O¥i¥H¤W¸üªº

¥X²{²Ä4¶K¬J³¥...
²Ä8¶Kªº³£°µ¤F
§Ú¬O¥Îlocalhost testªº©Ò¥H®Ú¥»­øÅx«§¤W¸ü........´NËÝ©ñ«Y­Óappserv/www/discuz/¨ì

..............§Ú¬J·N«ä­ø«Y"ftp"¤W¸ü
«Yphpmyadmin¤º¦³­Ósql¤W¸ü¬J³¥..«Y«}d­Ó¤W¸ü¥ª¥ý??
http://tinypic.com/b3lwmd.gif

[¦¹©«³Ì«á¥Ñ davidtin ¦b 2005-8-24 ©ó 11:46 ­×§ï]

¥Î¤F bigdump.php «K·|¤À¬q¥N§A¤J sql, ¤£­n¥Î phpmyadmin ¤F

........
¥X²{²Ä4¶K¬J³¥...
¤@«östart import

¥i¯à¬O§A³Æ¥÷ªº mysql ¤Î¶×¤J mysql ªºª©¥»¤£¤@­P©Ò²£¥Íªº°ÝÃD

§Ú¤S¬°¤°»ò·|³o¼Ëªº ><«ÜºG§r >< ¤ñdªB¤Í¸Ü§Ú
===­^¤å==================================================

BigDump: Staggered MySQL Dump Importer ver. 0.21b
Processing file: bbs.sql

Starting at the line: 1

Error at the line 27: ) TYPE=MyISAM;

Query: CREATE TABLE `cdb_access` ( `uid` mediumint(8) unsigned NOT NULL default '0', `fid` smallint(6) unsigned NOT NULL default '0', `allowview` tinyint(1) NOT NULL default '0', `allowpost` tinyint(1) NOT NULL default '0', `allowreply` tinyint(1) NOT NULL default '0', `allowgetattach` tinyint(1) NOT NULL default '0', PRIMARY KEY (`uid`,`fid`) ) TYPE=MyISAM;

MySQL: Table 'cdb_access' already exists

Stopped on error

Start from the beginning (DROP the old tables before restarting)

?2003-2005 Alexey Ozerov - BigDump Home


===¤¤¤å=================================================
BigDump: ·nÂ\ªºMySQL ÂàÀx¶i¤f°Óver ¡C 0.21b
³B²z¤å¥ó: bbs ¡Csql

¶}©l¦b½u: 1

¿ù»~¦b½u27: ) TYPE=MyISAM;

¸ß°Ý: ³Ð³yªí` cdb_access` (` uid` mediumint(8) ¥¼Ã±¦Wªº¤£ªÅ¯Ê¬Ù' 0 ', ` fid` smallint(6) ¥¼Ã±¦Wªº¤£ªÅ¯Ê¬Ù' 0 ', ` allowview` tinyint(1) ¤£ªÅ¯Ê¬Ù' 0 ', ` allowpost` tinyint(1) ¤£ªÅ¯Ê¬Ù' 0 ', ` allowreply` tinyint(1) ¤£ªÅ¯Ê¬Ù' 0 ', ` allowgetattach` tinyint(1) ¤£ªÅ¯Ê¬Ù' 0 ', ¥DÃöÁä¦r(`UID`,` fid`)) TYPE=MyISAM;

MySQL: ªí' cdb_access ªº¤w¸g¦s¦b

°±¤î¦b¿ù»~

¶}©l±q¤@¶}©l(§ë¤U¦Ñ®à¦b­«·s¶}©l¤§«e)

?2003-2005 Alexey Ozerov - BigDump ®a®x

[¦¹©«³Ì«á¥Ñ ufo269 ¦b 2005-10-29 ©ó 23:05 ­×§ï]

http://www.alan888.com/Discuz/vi ... d=42268&fpage=1

¤j¤j
¥Î½Æ»s¤À¬q¶K¤W,À³¸Ó¤]¥i¥H¹F¨ì¦P¼Ë®ÄªG§a?

¥u¬O¤ñ¸û¨¯­W...

§Aªº¸ê®Æ®w¸Ì¤w¦³¦P¦Wªºtable¦s¦b,©Ò¥Hsql¨S¿ìªk¶×¤J...À³¸Ó¬O³o¼Ë¤l§a..

¥i¥H«Ø¥ß¤@­Ó·s¸ê®Æ®w,µM«á­«·s¶×¤J..(Discuz¸Ìconfig.php¸Ì­n¥hÅܧó)

©Î§â¸ê®Æ®w¸Ì²MªÅ,¦A¶×¤J...


§Ú¬O·s¤â,­Ó¤H·N¨£¶È¨Ñ°Ñ¦Ò...  ©êºp!

­ø±o§r !!§Ú¬O¹L¥ª¤F !!
¤£¹L§Ú !!del¥ªd¶K!!´N¤W¸ü¨ì°Õ !!
><¨Ì®a¾ã¨ì§Ú©È¥ª ©O®a³¥

Discuz! info: MySQL Query Error

Time: 2005-12-5 11:56am
Script: /discuz/index.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.lastolupdate, s.seccode, m.uid AS discuz_uid, m.username AS discuz_user, m.gender as discuz_sex, m.password AS discuz_pw, m.nickname, m.secques AS discuz_secques, m.adminid,m.groupid, m.groupexpiry, m.email, m.timeoffset, m.tpp, m.ppp, m.posts, m.digestposts, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6, m.extcredits7, m.extcredits8, m.regdate, m.timeformat, m.dateformat, m.sigstatus, m.invisible, m.disablesigviews, m.lastvisit, m.lastactivity, m.lastpost, m.newpm, m.accessmasks FROM cdb_sessions s , cdb_members m WHERE s.sid='L5BgPP' AND m.uid=s.uid AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='219.77.73.118' AND m.uid='1' AND m.password='b31dab51189c6228d498acb62fb6e154' AND m.secques='ac6d47bf' LIMIT 1
Error: Unknown column 'm.nickname' in 'field list'
Errno.: 1054

Similar error report has beed dispatched to administrator before.
  

¾É¤J§¹~...
«§³£ÅÜ®Í.......

ÀɮשM¸ê®Æ®w­n¨D¤£¤@¼Ë