急!mysql dump出来的文件恢复不回去
iq199 2003-11-07 10:22:47 mysql xtdb < xtdb.sql
报错如下
ERROR 1064 at line 629: 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 '
right varchar(4) DEFAULT '' NOT NULL,
UNIQUE empright_x (log
我的文件629行如下:
CREATE TABLE empright (
login varchar(20) DEFAULT '' NOT NULL,
right varchar(4) DEFAULT '' NOT NULL,
UNIQUE empright_x (login,right)
);
另外我的源数据库的版本是3.22.27
目标数据库的版本是4.0.16-standard
和这个有关系吗?