WordPress.org

1. aeroman
   Member
   Posted 2 years ago #

   Hi ! ,

   I am trying to restore my wordpress database.

   When i import my old database i get the following error message. The tables are partially imported and WP POSTS, USERS etc. are missing .

   =================================================
   Error
   SQL query:
   CREATE TABLE wp_posts ( ID bigint(20) unsigned NOT NULL auto_increment, post_author ........

   MySQL said: Documentation
   #1170 - BLOB/TEXT column 'post_content' used in key specification without a key length

   ==================================================
   Help me out Guys !

2. aeroman
   Member
   Posted 2 years ago #

   Anybody wise enuff to reply here....

3. aeroman
   Member
   Posted 2 years ago #

   MySQL said: Documentation
   #1170 - BLOB/TEXT column 'post_content' used in key specification without a key length

   The above error was due to corrupt tables in the database. Since 2-3 upgrades were carried out on top of the original 2.6.1 , so its likely to somehow get corrupted.

   Opened up the SQL file in Notepad edited manually and reuploaded . Problem was fixed.

   Every blogger should learn a bit of Database Maintainence .

4. whooami
   Member
   Posted 2 years ago #

   Every web site owner that uses mysql should learn a bit of Database Maintainence .

   fixed that for you.

Topic Closed

This topic has been closed to new replies.