{"id":1078534,"date":"2009-05-15T12:15:26","date_gmt":"2009-05-15T12:15:26","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-table-structure\/"},"modified":"2016-08-19T12:50:13","modified_gmt":"2016-08-19T12:50:13","slug":"sql-table-structure","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-table-structure\/","title":{"rendered":"SQL Table Structure"},"content":{"rendered":"<p>After 4 years of archives, and absolutely no issues with WordPress at all. My database has become corrupt.  I&#8217;ve installed a fresh one (2.7.1) through my Fantastico host and I&#8217;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&#8217;d cut my losses there.<\/p>\n<p>So anyway &#8211; I&#8217;m an organizational freak and I&#8217;ve been through just about every structure I could get my hands on.  Which table in the SQL are the CATEGORIES located on?  <\/p>\n<p>And why do I have the itching feeling that it&#8217;s on one of the corrupt structures?<\/p>\n<p>HELP?<\/p>\n","protected":false},"template":"","class_list":["post-1078534","topic","type-topic","status-closed","hentry","topic-tag-database","topic-tag-sql","topic-tag-table-structure"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/1078534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/1078534\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=1078534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}