WordPress.org

1. rleon
   Member
   Posted 3 years ago #

   I am in the process of moving hosting providers.

   I have been able to export and import all of my websites and now I am in the processes of moving my biggest and last one.

   When I try to import my db I am able to import every table expect for one.

   I get the following error:

   CREATE TABLE wp_bdprss_items (
   item_feed_url varchar( 240 ) NOT NULL default '',
   item_url varchar( 255 ) NOT NULL default '',
   item_name varchar( 255 ) NOT NULL default '',
   ref_number int( 5 ) NOT NULL default '0',
   text text NOT NULL ,
   item_time int( 15 ) default NULL ,
   item_update_time int( 15 ) NOT NULL default '0',
   PRIMARY KEY ( item_feed_url , item_url ) ,
   KEY feed_index ( item_feed_url ) ,
   KEY update_index ( item_update_time ) ,
   KEY time_index ( item_time )
   ) TYPE = MYISAM ;

   MySQL said: Documentation
   #1071 - Specified key was too long; max key length is 1000 bytes

Topic Closed

This topic has been closed to new replies.