USING BTREE and older MySQL

[Jivanmukta]

Hello
I created a database in last version of MySQL. I generated script to
create tables (for this database). When I try to import this script
into older version of MySQL (distributed with Fedora 8), I receive
error that USING BTREE command is not understood. Here is sample table
from my database:

DROP TABLE IF EXISTS `estate_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estate_types` (
`estate_type_id` varchar(5) NOT NULL COMMENT 'Rodzaj nieruchomosci',
`estate_type_name` varchar(33) NOT NULL COMMENT 'Nazwa rodzaju
nieruchomosci',
PRIMARY KEY (`estate_type_id`),
KEY `index_estate_type_name` (`estate_type_name`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COMMENT='Rodzaje
nieruchomosci';
/*!40101 SET character_set_client = @saved_cs_client */;

The problem is with USING BTREE.
Question: how to change the syntax to be able to import the script
into older MySQL?
Please help
Thanks in advance.

["Álvaro G. Vicario"]

Jivanmukta escribi�:

If you happen to use mysqldump (you don't say) this can be a fix:

http://www.evanscode.com/2009/08/16/quicktip-how-to-resolve-using-btree-errors-when-importing-into-a-mysql-5-0-database/

--
-- http://alvaro.es - �lvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programaci�n web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--