Member Avatar for davy_yg

Hello,

I am trying to migrate sql file from one computer to another computer. And while trying to import the sql file these error appears why is it? I am trying to migrate sql from Joomla.

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 right syntax to use near 'USING BTREE

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

Edited by pritaeas because: Moved to MySQL forum
  • 3 Contributors
  • 9 Replies
  • 288 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by davy_yg

Recommended Answers

All 9 Replies

Member Avatar for pritaeas

Are both MySQL servers identical? The error states that BTREE is not supported, this is caused most likely if you are trying to import a dump from a new version into an older version of MySQL. If you want it to work, remove all occurences of "USING BTREE".

Member Avatar for davy_yg

how to remove all occurences using BTREE ?

Member Avatar for davy_yg

how? what's the syntax?

Edited by davy_yg
Member Avatar for davy_yg

hmm.. I never done it before.

Member Avatar for abhishekabhi

HI

which type of sql error.

commented: The error is clearly visible in the OP's post. -3
Member Avatar for davy_yg

It now works. I upgraded my xampp version to a newer one.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.