Support » Fixing WordPress » I need to create the link table in mysql

  • I seemed to have corrupted my wp_links table of my database. I tinkered around in the database and I dropped the table and recreated a new wp_link table. But I don’t know what fields it should have. Any advice?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Um….

    This is the stuff from one of my db dumps:


    — Table structure for table wp_links

    CREATE TABLE wp_links (
    link_id bigint(20) NOT NULL auto_increment,
    link_url varchar(255) NOT NULL default ”,
    link_name varchar(255) NOT NULL default ”,
    link_image varchar(255) NOT NULL default ”,
    link_target varchar(25) NOT NULL default ”,
    link_category bigint(20) NOT NULL default ‘0’,
    link_description varchar(255) NOT NULL default ”,
    link_visible enum(‘Y’,’N’) NOT NULL default ‘Y’,
    link_owner int(11) NOT NULL default ‘1’,
    link_rating int(11) NOT NULL default ‘0’,
    link_updated datetime NOT NULL default ‘0000-00-00 00:00:00’,
    link_rel varchar(255) NOT NULL default ”,
    link_notes mediumtext NOT NULL,
    link_rss varchar(255) NOT NULL default ”,
    PRIMARY KEY (link_id),
    KEY link_category (link_category),
    KEY link_visible (link_visible)
    ) TYPE=MyISAM AUTO_INCREMENT=23 ;

    This is for 2.0.1…

    And in fact you should be able to drop the empty table you created and just sql query that one the way it stands.

    Thread Starter dmbosstone

    (@dmbosstone)

    Thanks a lot- it did the trick!

    You’re welcome!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘I need to create the link table in mysql’ is closed to new replies.