0

Hello,

I am trying to import mysql backup from the old computer to the new computer and these error appears:

Pencarian SQL:

-- --------------------------------------------------------

-- Table structure for table nafqc_usergroups

CREATE TABLE IF NOT EXISTS nafqc_usergroups (

id int( 10 ) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
parent_id int( 10 ) unsigned NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id',
lft int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
rgt int( 11 ) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
title varchar( 100 ) NOT NULL DEFAULT '',
PRIMARY KEY ( id ) ,
UNIQUE KEY idx_usergroup_parent_title_lookup ( parent_id , title ) ,
KEY idx_usergroup_title_lookup ( title ) ,
KEY idx_usergroup_adjacency_lookup ( parent_id ) ,
KEY idx_usergroup_nested_set_lookup ( lft , rgt ) USING BTREE) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =13;

MySQL menyatakan:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the www.daniweb.comear 'USING BTREE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13' at line 17

What should I do ?

Edited by peter_budo: Please make sure you do not post same question multiple times! LOCKED

3
Contributors
2
Replies
5
Views
4 Years
Discussion Span
Last Post by peter_budo
0

@davy_yg

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the www.daniweb.comear 'USING BTREE

Your MySQL server version is old and is not compatible with the one you have that's the error came up.