All I'm trying to do is add a fulltext index onto an existing MyISAM table using MySQL 4.0.10:
-- File: INDEXES.SQL
-- Created: 8/24/2004
-- Modified:
-- Purpose: Create CMA table indexes
-- Dependencies: MySQL 3.23+ Database, MyISAM tables
-- Privacy Scope: SQL file. Be sure to render lockdown on /sql folder to prevent viewing/downloading of this script
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
ALTER TABLE contacts ADD FULLTEXT ft_contacts
(title, first_name, last_name, position, school_company_org, department, address1, address2, address3, city, state, country, main_email, alt_email, url);
When I run this SQL file using command-line MySQL:
. /var/www/html/cma/sql/cma.sql
I get the following error:
ERROR 1005: Can't create table './cma/#sql-30c_2da6.frm' (errno: 140)
mysql>
WTH???? Someone please explain this one to me I am completely confused and cannot even figure it out using Google (wound up with this page http://lists.mysql.com/mysql/168367
Thanx
Phil
