:::
一般研習學員
2006-08-27 08:07:57
資料庫從xp移轉b2d出現以下錯誤訊息(麻煩tad老師解救)
2006-08-27 08:07:57
路過的訪客
我在xp利用appserv建立apache與mysql,mysql語系預設值是default-character-set=latin1
(# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1
)
我在xp利用phpmyadmin將xoops資料庫匯出檔案(xoops_backup.sql)
然後在b2d再用同樣的方式轉入，結果出現以下錯誤訊息，請問我該如何解決呢?
SQL 語法:
CREATE TABLE `xoops_avatar` (
`avatar_id` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`avatar_file` varchar( 30 ) NOT NULL default '',
`avatar_name` varchar( 100 ) NOT NULL default '',
`avatar_mimetype` varchar( 30 ) NOT NULL default '',
`avatar_created` int( 10 ) NOT NULL default '0',
`avatar_display` tinyint( 1 ) unsigned NOT NULL default '0',
`avatar_weight` smallint( 5 ) unsigned NOT NULL default '0',
`avatar_type` char( 1 ) NOT NULL default '',
PRIMARY KEY ( `avatar_id` ) ,
KEY `avatar_type` ( `avatar_type` , `avatar_display` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1
MySQL 傳回： 說明文件
#1064 - 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 12
(# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1
)
我在xp利用phpmyadmin將xoops資料庫匯出檔案(xoops_backup.sql)
然後在b2d再用同樣的方式轉入，結果出現以下錯誤訊息，請問我該如何解決呢?
SQL 語法:
CREATE TABLE `xoops_avatar` (
`avatar_id` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`avatar_file` varchar( 30 ) NOT NULL default '',
`avatar_name` varchar( 100 ) NOT NULL default '',
`avatar_mimetype` varchar( 30 ) NOT NULL default '',
`avatar_created` int( 10 ) NOT NULL default '0',
`avatar_display` tinyint( 1 ) unsigned NOT NULL default '0',
`avatar_weight` smallint( 5 ) unsigned NOT NULL default '0',
`avatar_type` char( 1 ) NOT NULL default '',
PRIMARY KEY ( `avatar_id` ) ,
KEY `avatar_type` ( `avatar_type` , `avatar_display` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1
MySQL 傳回： 說明文件
#1064 - 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 12
記得利用 pspad 的取代功能
將「DEFAULT CHARSET = latin1」全部取代成空白...
這樣就行了。
將「DEFAULT CHARSET = latin1」全部取代成空白...
這樣就行了。
