mysql syntax error ?

hi,

I receive this error when I export/import a table from a database to another one:

Error
SQL query:

--
-- Database: `mil`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_taoj`
--
CREATE TABLE IF NOT EXISTS  `jos_taoj` (

 `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
 `extension` VARCHAR( 100 ) NOT NULL COMMENT  'The extension',
 `version` VARCHAR( 16 ) NOT NULL COMMENT  'Version number',
 `installed_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT  'Date-time modified or installed',
 `log` MEDIUMTEXT,
PRIMARY KEY (  `id` ) USING BTREE,
KEY  `idx_extension` (  `extension` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COMMENT =  'The Art of Joomla extension version history' AUTO_INCREMENT =2;

MySQL said: 

#1064 - Erreur de syntaxe pr�s de 'USING BTREE,
  KEY `idx_extension` (`extension`)
) ENGINE=MyISAM' � la ligne 7 

could you give me some help ?

thanks

Hi.

Should it not be:

PRIMARY KEY USING BTREE(  `id` ),

Your SQL query has been executed successfully (Query took 0.0847 sec)

SQL query:
CREATE TABLE IF NOT EXISTS `jos_taoj` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`extension` VARCHAR( 100 ) NOT NULL COMMENT 'The extension',
`version` VARCHAR( 16 ) NOT NULL COMMENT 'Version number',
`installed_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date-time modified or installed',
`log` MEDIUMTEXT,
PRIMARY KEY USING BTREE(
`id` 
),
KEY `idx_extension` ( `extension` ) 
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =2;

Are you exporting/importing between different MySQL versions?
Take a look at the --compatible option of the mysqldump command.