HELP: moving DB to another server probs :(

[kevingpo]

I exported my database so that I can move my website to another server PC. Upon importing into the new MySQL server I get this error messsage. I had a look at MySQL website but to no avail I still did not know what it means or how to solve it. Please can someone help me solve this bug.


MySQL said: 

#1170 - BLOB/TEXT column 'caption' used in key specification without a key length

#
# Dumping data for table 'nuke_cpg_exif'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_cpg_pictures'
#
CREATE TABLE nuke_cpg_pictures(

pid int( 11 ) NOT NULL AUTO_INCREMENT ,
aid int( 11 ) DEFAULT '0' NOT NULL ,
filepath varchar( 255 ) NOT NULL ,
filename varchar( 255 ) NOT NULL ,
filesize int( 11 ) DEFAULT '0' NOT NULL ,
total_filesize int( 11 ) DEFAULT '0' NOT NULL ,
pwidth smallint( 6 ) DEFAULT '0' NOT NULL ,
pheight smallint( 6 ) DEFAULT '0' NOT NULL ,
hits int( 10 ) DEFAULT '0' NOT NULL ,
mtime timestamp DEFAULT 'CURRENT_TIMESTAMP',
ctime int( 11 ) DEFAULT '0' NOT NULL ,
owner_id int( 11 ) DEFAULT '0' NOT NULL ,
owner_name varchar( 40 ) NOT NULL ,
pic_rating int( 11 ) DEFAULT '0' NOT NULL ,
votes int( 11 ) DEFAULT '0' NOT NULL ,
title varchar( 255 ) NOT NULL ,
caption text NOT NULL ,
keywords varchar( 255 ) NOT NULL ,
approved enum( 'YES', 'NO' ) DEFAULT 'NO' NOT NULL ,
user1 varchar( 255 ) NOT NULL ,
user2 varchar( 255 ) NOT NULL ,
user3 varchar( 255 ) NOT NULL ,
user4 varchar( 255 ) NOT NULL ,
url_prefix tinyint( 4 ) DEFAULT '0' NOT NULL ,
randpos int( 11 ) DEFAULT '0' NOT NULL ,
pic_raw_ip tinytext,
pic_hdr_ip tinytext,
PRIMARY KEY ( pid ) ,
KEY pic_hits( hits ) ,
KEY pic_rate( pic_rating ) ,
KEY aid_approved( aid, approved ) ,
KEY randpos( randpos ) ,
KEY pic_aid( aid ) ,
KEY search( title, caption, keywords, filename )
)

[Joachim Müller]

no nuke support on this forum, because we don't know the nuke port. Read the sticky thread on the sub-board I'm moving your posting to.

Joachim