• 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

The topic ‘Exporting importing issue with wp_bdprss_items table’ is closed to new replies.