AllI use XCloner to backup my joomla sites and restore to a different host, been using this for a couple of years. However, before my next move I checked out a site I built on my local pc, setup another test directory, another new DB (empty) and ran a restore on a backup I had taken. XCloner first unzips all the joomla directory and data structures, then in the new target database it builds the joomla database.All worked as expected except ALL my K2 tables failed - see below.Can anyone comment as to why K2 doesnt support FULL TEXT but more importantly what I need to do to workaround this problem.ThanksGeorgeXCloner Automatic Restore! Configuration updated! There were some errors while importing the database:

##Mysql Query: ######## CREATE TABLE `jos_k2_items` ( `id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL, `alias` varchar(255) default NULL,
`catid` int(11) NOT NULL, `published` smallint(6) NOT NULL default '0',
`introtext` text NOT NULL, `fulltext` text NOT NULL, `video` text,
`gallery` varchar(255) default NULL, `extra_fields` text character set
utf8 collate utf8_unicode_ci, `extra_fields_search` text NOT NULL,
`created` datetime NOT NULL, `created_by` int(11) NOT NULL default '0',
`created_by_alias` varchar(255) NOT NULL, `checked_out` int(10)
unsigned NOT NULL, `checked_out_time` datetime NOT NULL, `modified`
datetime NOT NULL, `modified_by` int(11) NOT NULL default '0',
`publish_up` datetime NOT NULL, `publish_down` datetime NOT NULL,
`trash` smallint(6) NOT NULL default '0', `access` int(11) NOT NULL
default '0', `ordering` int(11) NOT NULL default '0', `featured`
smallint(6) NOT NULL default '0', `featured_ordering` int(11) NOT NULL
default '0', `image_caption` text NOT NULL, `image_credits`
varchar(255) NOT NULL, `video_caption` text NOT NULL, `video_credits`
varchar(255) NOT NULL, `hits` int(10) unsigned NOT NULL, `params` text
NOT NULL, `metadesc` text NOT NULL, `metadata` text NOT NULL,
`metakey` text NOT NULL, `plugins` text NOT NULL, PRIMARY KEY (`id`),
KEY `item` (`published`,`publish_up`,`publish_down`,`trash`,`access`),
KEY `catid` (`catid`), KEY `created_by` (`created_by`), KEY
`ordering` (`ordering`), KEY `featured` (`featured`), KEY
`featured_ordering` (`featured_ordering`), KEY `hits` (`hits`), KEY
`created` (`created`), FULLTEXT KEY `search`
(`title`,`introtext`,`fulltext`,`extra_fields_search`,`image_caption`,`image_credits`,`video_caption`,`video_credits`,`metadesc`,`metakey`),
FULLTEXT KEY `title` (`title`)); ######## ##Error message: The used table type doesn't support FULLTEXT indexes

##Mysql Query: ######## INSERT INTO jos_k2_items VALUES
('1','Dedication','dedication','1','1','<p style=\"text-align:
center;\">\r\n <span style=\"font-size: 24px;\"><span
style=\"color: rgb(0, 0, 139);\">Dedicated to
James</span></span></p>\r\n<p>\r\n {loadposition
fps1}</p>\r\n<p style=\"text-align: center;\">\r\n <span
style=\"font-size: 24px;\"><strong><span style=\"color:
rgb(0, 0, 139);\">IN MEMORY</span> <span style=\"color:
rgb(0, 0, 139);\">OF</span> <span style=\"color: rgb(0, 0,
139);\">JAMES JERZY
SZUBINSKI</span></strong></span></p>\r\n<p
style=\"text-align: center;\">\r\n <span style=\"font-size:
24px;\"><strong><span style=\"color: rgb(0, 0,
139);\">1973 –
2007</span></strong></span><strong><span
_fck_bookmark=\"1\" style=\"display: none;\">
</span></strong></p>\r\n<p style=\"text-align:
center;\">\r\n <span style=\"color: rgb(0, 0, 128);\">'Those we
love don’t go away<br />\r\n <br />\r\n they walk beside us
everyday<br />\r\n <br />\r\n Forever In our
Hearts'</span></p>\r\n<p>\r\n <span
_fck_bookmark=\"1\" style=\"display: none;\">
</span></p>\r\n<p align=\"left\">\r\n {audio
autostart}images/stories/music/09 - U2 - Beautiful
Day.mp3{/audio}</p>\r\n<p align=\"left\">\r\n On the
20<sup>th</sup> February 1973 my wife Janis gave birth to a
beautiful boy, we called him James. I remember thinking how wonderful
life was and how it was a beautiful day. We had a great family were very
close, caring and loving. James and his sister Joanne have always been
very special to Janis and me. On the 5<sup>th</sup> June
2007, after a particularly nasty accident at home, God relieved James of
his pain and he died.I remember looking out of the window at the
hospital, at all the people busy going to work and thinking to myself –
it is a beautiful day.</p>\r\n<p align=\"left\">\r\n Janis,
Joanne, George and Dave would like to thank the Redditch A&E
department and to pay a huge tribute to the wonderful ICU teams at the
John Radcliffe Hospital who worked hard attempting to save James' life.
Their professionalism and compassion is simply
remarkable.</p>\r\n<p align=\"left\">\r\n We would like to
thank everyone who were so generous with their financial donations. The
total amount of money donated was £784.50 and was sent to the John
Radcliffe Hospital.</p>\r\n<p align=\"left\">\r\n If anyone
has problems with this website or needs to contact me - <a
href=\"mailto:[email protected]\">email
me</a></p>','','','','[]','','2010-07-14
23:54:43','62','','0','0000-00-00 00:00:00','2010-07-29
18:22:33','62','2010-07-14 23:54:43','0000-00-00
00:00:00','0','0','1','0','0','','','','','1','catItemTitle=0\r\ncatItemTitleLinked=0\r\ncatItemFeaturedNotice=0\r\ncatItemAuthor=0\r\ncatItemDateCreated=0\r\ncatItemRating=0\r\ncatItemImage=0\r\ncatItemIntroText=1\r\ncatItemExtraFields=0\r\ncatItemHits=0\r\ncatItemCategory=0\r\ncatItemTags=\r\ncatItemAttachments=\r\ncatItemAttachmentsCounter=\r\ncatItemVideo=\r\ncatItemVideoWidth=\r\ncatItemVideoHeight=\r\ncatItemVideoAutoPlay=\r\ncatItemImageGallery=\r\ncatItemDateModified=\r\ncatItemReadMore=0\r\ncatItemCommentsAnchor=\r\ncatItemK2Plugins=\r\nitemDateCreated=\r\nitemTitle=\r\nitemFeaturedNotice=\r\nitemAuthor=\r\nitemFontResizer=\r\nitemPrintButton=\r\nitemEmailButton=\r\nitemSocialButton=\r\nitemVideoAnchor=\r\nitemImageGalleryAnchor=\r\nitemCommentsAnchor=\r\nitemRating=\r\nitemImage=\r\nitemImgSize=\r\nitemImageMainCaption=\r\nitemImageMainCredits=\r\nitemIntroText=\r\nitemFullText=\r\nitemExtraFields=\r\nitemDateModified=\r\nitemHits=\r\nitemTwitterLink=\r\nitemCategory=\r\nitemTags=\r\nitemShareLinks=\r\nitemAttachments=\r\nitemAttachmentsCounter=\r\nitemRelated=\r\nitemRelatedLimit=\r\nitemVideo=\r\nitemVideoWidth=\r\nitemVideoHeight=\r\nitemVideoAutoPlay=\r\nitemVideoCaption=\r\nitemVideoCredits=\r\nitemImageGallery=\r\nitemNavigation=\r\nitemComments=\r\nitemAuthorBlock=\r\nitemAuthorImage=\r\nitemAuthorDescription=\r\nitemAuthorURL=\r\nitemAuthorEmail=\r\nitemAuthorLatest=\r\nitemAuthorLatestLimit=\r\nitemK2Plugins=\r\n\r\n','','robots=\r\nauthor=','','');
######## ##Error message: Table 'jjtest.jos_k2_items' doesn't exist

##Mysql Query: ######## INSERT INTO jos_k2_items VALUES ('2','Dedicate
2','dedicate-2','1','1','<p>\r\n This site is dedicated to you my
son, my very best friend.</p>\r\n<p align=\"left\">\r\n
James was a terrific guy, full of boundless energy and incredible
humour. He worked hard, was highly respected and had many, many friends.
He was married to Sarah and has two beautiful children – Chloe and
Kai.</p>\r\n<p align=\"left\">\r\n His best mate was Dave
who later on in their friendship fell in love with and married James'
sister Joanne. Dave and Jo’s children Abbie and Ellis miss those happy
days with their favourite uncle James and their cousins and pals Chloe
and Kai.</p>\r\n<p align=\"left\">\r\n James’ funeral was
held at Redditch Crematorium Chapel on the 15<sup>th</sup>
June, his ashes were scattered by Sarah by the only tree in Arrow Mill’s
grounds in October. A plaque in memory of James has been placed by a
beautiful tree in St Leonard’s cemetery Boeley (close to a bench) as
part of a small dedication service during March 2008. If you are in the
area please pay James a visit.</p>\r\n<p align=\"left\">\r\n
This site is here for all his friends and family to view, share in
happier memories and leave their thoughts.</p>\r\n<p
align=\"left\">\r\n </p>\r\n<p align=\"left\">\r\n
</p>\r\n<p>\r\n </p>\r\n<table border=\"0\"
style=\"height: 132px;\" width=\"817\">\r\n <tbody>\r\n
<tr>\r\n <td>\r\n </td>\r\n <td>\r\n
</td>\r\n </tr>\r\n
</tbody>\r\n</table>','','','','[]','','2010-07-15
00:01:17','62','','0','0000-00-00 00:00:00','2010-07-15
17:30:14','62','2010-07-15 00:01:17','0000-00-00
00:00:00','0','0','2','0','0','','','','','0','catItemTitle=0\r\ncatItemTitleLinked=0\r\ncatItemFeaturedNotice=\r\ncatItemAuthor=0\r\ncatItemDateCreated=0\r\ncatItemRating=0\r\ncatItemImage=0\r\ncatItemIntroText=\r\ncatItemExtraFields=0\r\ncatItemHits=0\r\ncatItemCategory=0\r\ncatItemTags=0\r\ncatItemAttachments=0\r\ncatItemAttachmentsCounter=0\r\ncatItemVideo=0\r\ncatItemVideoWidth=\r\ncatItemVideoHeight=\r\ncatItemVideoAutoPlay=\r\ncatItemImageGallery=\r\ncatItemDateModified=0\r\ncatItemReadMore=0\r\ncatItemCommentsAnchor=0\r\ncatItemK2Plugins=\r\nitemDateCreated=\r\nitemTitle=\r\nitemFeaturedNotice=\r\nitemAuthor=\r\nitemFontResizer=\r\nitemPrintButton=\r\nitemEmailButton=\r\nitemSocialButton=\r\nitemVideoAnchor=\r\nitemImageGalleryAnchor=\r\nitemCommentsAnchor=\r\nitemRating=\r\nitemImage=\r\nitemImgSize=\r\nitemImageMainCaption=\r\nitemImageMainCredits=\r\nitemIntroText=\r\nitemFullText=\r\nitemExtraFields=\r\nitemDateModified=\r\nitemHits=\r\nitemTwitterLink=\r\nitemCategory=\r\nitemTags=\r\nitemShareLinks=\r\nitemAttachments=\r\nitemAttachmentsCounter=\r\nitemRelated=\r\nitemRelatedLimit=\r\nitemVideo=\r\nitemVideoWidth=\r\nitemVideoHeight=\r\nitemVideoAutoPlay=\r\nitemVideoCaption=\r\nitemVideoCredits=\r\nitemImageGallery=\r\nitemNavigation=\r\nitemComments=\r\nitemAuthorBlock=\r\nitemAuthorImage=\r\nitemAuthorDescription=\r\nitemAuthorURL=\r\nitemAuthorEmail=\r\nitemAuthorLatest=\r\nitemAuthorLatestLimit=\r\nitemK2Plugins=\r\n\r\n','','robots=\r\nauthor=','','');
######## ##Error message: Table 'jjtest.jos_k2_items' doesn't exist

##Mysql Query: ######## INSERT INTO jos_k2_items VALUES ('3','Messages to
James','messages-to-james','2','1','<p>\r\n Please leave your
messages to James here:<br />\r\n
</p>','','','','[]','','2010-07-15
18:27:05','62','','0','0000-00-00 00:00:00','0000-00-00
00:00:00','0','2010-07-15 18:27:05','0000-00-00
00:00:00','0','0','1','0','0','','','','','13','catItemTitle=\r\ncatItemTitleLinked=\r\ncatItemFeaturedNotice=\r\ncatItemAuthor=\r\ncatItemDateCreated=\r\ncatItemRating=\r\ncatItemImage=\r\ncatItemIntroText=\r\ncatItemExtraFields=\r\ncatItemHits=\r\ncatItemCategory=\r\ncatItemTags=\r\ncatItemAttachments=\r\ncatItemAttachmentsCounter=\r\ncatItemVideo=\r\ncatItemVideoWidth=\r\ncatItemVideoHeight=\r\ncatItemVideoAutoPlay=\r\ncatItemImageGallery=\r\ncatItemDateModified=\r\ncatItemReadMore=\r\ncatItemCommentsAnchor=\r\ncatItemK2Plugins=\r\nitemDateCreated=\r\nitemTitle=\r\nitemFeaturedNotice=\r\nitemAuthor=\r\nitemFontResizer=\r\nitemPrintButton=\r\nitemEmailButton=\r\nitemSocialButton=\r\nitemVideoAnchor=\r\nitemImageGalleryAnchor=\r\nitemCommentsAnchor=\r\nitemRating=\r\nitemImage=\r\nitemImgSize=\r\nitemImageMainCaption=\r\nitemImageMainCredits=\r\nitemIntroText=\r\nitemFullText=\r\nitemExtraFields=\r\nitemDateModified=\r\nitemHits=\r\nitemTwitterLink=\r\nitemCategory=\r\nitemTags=\r\nitemShareLinks=\r\nitemAttachments=\r\nitemAttachmentsCounter=\r\nitemRelated=\r\nitemRelatedLimit=\r\nitemVideo=\r\nitemVideoWidth=\r\nitemVideoHeight=\r\nitemVideoAutoPlay=\r\nitemVideoCaption=\r\nitemVideoCredits=\r\nitemImageGallery=\r\nitemNavigation=\r\nitemComments=\r\nitemAuthorBlock=\r\nitemAuthorImage=\r\nitemAuthorDescription=\r\nitemAuthorURL=\r\nitemAuthorEmail=\r\nitemAuthorLatest=\r\nitemAuthorLatestLimit=\r\nitemK2Plugins=\r\n\r\n','','robots=\r\nauthor=','','');
######## ##Error message: Table 'jjtest.jos_k2_items' doesn't exist

##Mysql Query: ######## CREATE TABLE `jos_k2_tags` ( `id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL, `published` smallint(6) NOT NULL default
'0', PRIMARY KEY (`id`), KEY `published` (`published`), FULLTEXT KEY
`name` (`name`)); ######## ##Error message: The used table type doesn't support FULLTEXT indexes

Apologies,

I have researched further. This is a known MySql bug.

Looks like I need to specify the Engine type as MYISAM.

See

george