Can’t restore wordpress databse through PhpMyAdmin

  • Resolved aeroman

    (@aeroman)


    15 years, 8 months 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 !

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter aeroman

    (@aeroman)

    Anybody wise enuff to reply here….

    Thread Starter aeroman

    (@aeroman)

    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 .

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

    fixed that for you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Can’t restore wordpress databse through PhpMyAdmin’ is closed to new replies.