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 ?

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

Not sure if this is a problem (or the answer), but you have unbalanced parentheses ')' in the offending line.

Sorry, I had a closer look. That is not the problem.

Edited by cliff.strange.9

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.