Drupal MySQL Import Error

I’m very new to all this which is probably why I’m posting a drupal error on a wordpress forum, however this community appears to be not only very knowledgeable but also timely in your responses to cries for help.

I’m trying to move my site from one server to another. The issue is when trying to import the MySQL database onto the new server:

SQL query:

—
— Dumping data for table content_type_story
—
— ——————————————————–
—
— Table structure for table copy_rule
—
CREATE TABLE copy_rule (
rid int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
to_type varchar( 25 ) NOT NULL default ”,
src_arg int( 10 ) unsigned NOT NULL default ‘0’,
fields_thief varchar( 1024 ) NOT NULL default ”,
PRIMARY KEY ( rid ) ,
UNIQUE KEY to_type ( to_type )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;

MySQL said: Documentation
#1074 – Column length too big for column ‘fields_thief’ (max = 255); use BLOB or TEXT instead

Any ideas???