Database Export

I have built a site locally and now need to migrate to my live server. When I export the MySQL database it all seems fine, but when I try to import the database I get the following error:

REATE TABLE IF NOT EXISTS "jos_flexicontent_items_ext"(

"item_id"int( 11 ) unsigned NOT NULL ,
"type_id"int( 11 ) unsigned NOT NULL ,
"language"varchar( 11 ) NOT NULL DEFAULT '',
"sub_items"text NOT NULL ,
"sub_categories"text NOT NULL ,
"related_items"text NOT NULL ,
"search_index"mediumtext NOT NULL ,
PRIMARY KEY ( "item_id" ) ,
FULLTEXT KEY "search_index"( "search_index" )
);



MySQL said:

#1214 - The used table type doesn't support FULLTEXT indexes

Any help would be greatly appreciated.

Thanks
Gazza

Try Joomlapack on the entire site. We have used it several times with great results. It installs similar to a new installation but includes everything the previous site did.

an import export component (commercial) for flexicontent is comming by netassopro
regards

Hi Guys,

Posted the above issues a long time ago now. Does anyone have any idea how to resolve this problem. I don't want to have to purchase a component to do this, as it should be achievable with PHP MyAdmin.

Any help would be appreciated.

Thanks
Gazza

I see that in you table create statement you do not define the database engine.

Your new server may have default database engine InnoDB and not MyISAM.
Trying changing default engine of your server or use ENGINE = MyISAM in you create table statements

This is MySQL related issue, try looking in MySQL forums and also google-ing it ..

Regards