Support » Developing with WordPress » SQL Table Structure

  • After 4 years of archives, and absolutely no issues with WordPress at all. My database has become corrupt. I’ve installed a fresh one (2.7.1) through my Fantastico host and I’ve managed to import all of my old articles. However, there are a few tables that are corrupt and untouchable. wp_optioins, wp_terms and wp_comments. I figure I’d cut my losses there.

    So anyway – I’m an organizational freak and I’ve been through just about every structure I could get my hands on. Which table in the SQL are the CATEGORIES located on?

    And why do I have the itching feeling that it’s on one of the corrupt structures?

    HELP?

Viewing 5 replies - 1 through 5 (of 5 total)
  • whooami

    (@whooami)

    Member

    wp_terms

    reference:
    http://codex.wordpress.org/Database_Description

    .. and while we are at, can you describe “corrupt”? tables crash, they dont corrupt.
    Furthermore, crashed tables are repairable in nearly all circumstances, either from phpmyadmin, or some other gui based tool, and most definitely from the cli, since you can stop mysql to do it. (if your root, that is).

    DAMN!

    MySQL said:

    #145 – Table ‘./username_wrdp/wp_terms’ is marked as crashed and should be repaired

    That’s the error I get with it. Is there any way to repair it? The wp_term_relationships and wp_term_taxonomy tables appear to be fine. It’s just the initial wp_terms one that has crapped out on me.

    whooami

    (@whooami)

    Member

    Heres one way:

    To Check:

    1. Login to phpMyAdmin.
    2. Select the database and click on ‘Structure’ tab.
    3. Right under the list of table there is a “Check All” link. Click on it to select all tables.
    4. From a “With selected:” drop-down menu right next to it, choose “Check table”.

    To Repair:

    1. Login to phpMyAdmin
    2. Choose the affected database. If you only have one database, it should choose it by default so you don’t need to do anything.
    3. In the main panel, you should see a list of your database tables. Check the boxes by the tables that need repair.
    4. At the bottom of the window just below the list of tables, there is a drop down menu. Choose “Repair Table”

    Awesome! I was able to repair the old tables (but WordPress still wouldn’t properly work for me) so I imported them to the new installation and everything appears to be fine now.

    Thank you so much for your help!

    whooami

    (@whooami)

    Member

    yer welcome 🙂

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘SQL Table Structure’ is closed to new replies.