Title: Database upload error
Last modified: August 21, 2016

---

# Database upload error

 *  [KittyConway](https://wordpress.org/support/users/kittyconway/)
 * (@kittyconway)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/database-upload-error/)
 * I’m moving from localhost to a live site and have this error when I try to upload
   the database:
 * CREATE TABLE `wp_sfposts` (
 *  `post_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
    `post_content` LONGTEXT, `
   post_date` DATETIME NOT NULL , `topic_id` BIGINT( 20 ) NOT NULL , `user_id` BIGINT(
   20 ) , `forum_id` BIGINT( 20 ) NOT NULL , `guest_name` VARCHAR( 20 ) , `guest_email`
   VARCHAR( 50 ) , `post_status` INT( 4 ) NOT NULL DEFAULT ‘0’, `post_pinned` SMALLINT(
   1 ) NOT NULL DEFAULT ‘0’, `post_index` MEDIUMINT( 8 ) DEFAULT ‘0’, `post_edit`
   MEDIUMTEXT, `poster_ip` VARCHAR( 39 ) NOT NULL DEFAULT ‘0.0.0.0’, `comment_id`
   BIGINT( 20 ) , `source` SMALLINT( 1 ) NOT NULL DEFAULT ‘0’, PRIMARY KEY ( `post_id`),
   KEY `topicp_idx` ( `topic_id` ) , KEY `forump_idx` ( `forum_id` ) , KEY `user_idx`(`
   user_id` ) , KEY `guest_name_idx` ( `guest_name` ) , KEY `comment_idx` ( `comment_id`),
   KEY `post_date_idx` ( `post_date` ) , KEY `post_content` ( `post_content` ) )
   ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =2;
 * MySQL said: Documentation
    #1170 – BLOB/TEXT column ‘post_content’ used in key
   specification without a key length
 * There is a post which mentions this error but the fix isn’t clear enough for 
   me! I of course googled the error too and am looking at the database, but it 
   was working fine not long ago on the localhost. Getting desperate now, can someone
   help please? Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Moderator [t-p](https://wordpress.org/support/users/t-p/)
 * (@t-p)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/database-upload-error/#post-4558992)
 * a few related to moving from local to live server:
 * [http://wordpress.org/support/topic/moving-wp-from-local-host-to-live-server-need-most-current-instructions-please?replies=12](http://wordpress.org/support/topic/moving-wp-from-local-host-to-live-server-need-most-current-instructions-please?replies=12)
 * [http://wordpress.org/support/topic/moving-a-local-site-to-server-live?replies=4](http://wordpress.org/support/topic/moving-a-local-site-to-server-live?replies=4)
 * [http://www.wpbeginner.com/wp-tutorials/how-to-move-wordpress-from-local-server-to-live-site/](http://www.wpbeginner.com/wp-tutorials/how-to-move-wordpress-from-local-server-to-live-site/)
 *  Thread Starter [KittyConway](https://wordpress.org/support/users/kittyconway/)
 * (@kittyconway)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/database-upload-error/#post-4558993)
 * Thanks Tara, some good links in there I’ll keep hold of.
 *  I’ve managed to upload the database after having manually deleted all the wp_sf….
   tables – they were from Simple Press which I can worry about later if I ever 
   get the thing live! 🙂
 *  Moderator [t-p](https://wordpress.org/support/users/t-p/)
 * (@t-p)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/database-upload-error/#post-4558997)
 * Glad to hear that 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database upload error’ is closed to new replies.

## Tags

 * [error message](https://wordpress.org/support/topic-tag/error-message/)
 * [MySQL database](https://wordpress.org/support/topic-tag/mysql-database/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [t-p](https://wordpress.org/support/users/t-p/)
 * Last activity: [12 years, 3 months ago](https://wordpress.org/support/topic/database-upload-error/#post-4558997)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics