用SQLyog导入数据库的问题
把空间上的数据库备份下来后打算在本地导入,用SQLyog导入报告以下错误:
Query:
CREATE TABLE `ask_admin` (
`adminid` tinyint(3) unsigned NOT NULL default '0 ',
`adminname` char(30) NOT NULL default ' ',
`allowlogin` tinyint(1) default '0 ',
`allowadd` tinyint(1) default '0 ',
`allowdelete` tinyint(1) default '0 ',
`allowedit` tinyint(1) default '0 ',
`allowmanage` tinyint(1) default '0 '
) ENGINE=MyISAM DEFAULT CHARSET=gbk
Error occured at:2007-09-09 21:45:04
Line no.:29
Error Code: 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=gbk ' at line 9
请问怎么解决
------解决方案--------------------(0 row(s)affected)
(0 ms taken)
我的上面没有任何问题。
你的版本是多少?