Title: mysql error from post2cat table
Last modified: August 18, 2016

---

# mysql error from post2cat table

 *  [just_bruce](https://wordpress.org/support/users/just_bruce/)
 * (@just_bruce)
 * [21 years, 7 months ago](https://wordpress.org/support/topic/mysql-error-from-post2cat-table/)
 * My installation on windows 98 was working great. it is wordpress 1.2.1 with apache
   1.3.38 , php 4.3.8, and mysql 4.0.12.
    I did some stuff earlier today with spybot
   and adaware to clean up the machine and suddenly after that my post2cat table
   is hosed. I cant access it from php, from mysql or from phpadmin. the other wordpress
   tables seem ok, and functions on screens that do not go to post2cat work fine.
   I dont really have that much stuff only 5 categories and only about 60 posts.
   but of course i didnt back up database. Is there a way i can correct the post2cat
   table to match up with my other data which seems fine? or otherwise get the system
   going ok? anyone else have this problem? is there any doc on what the post2cat
   table structure is and how it is used? thanks a lot! the pain of no backup!! 
   just_bruce

Viewing 1 replies (of 1 total)

 *  Thread Starter [just_bruce](https://wordpress.org/support/users/just_bruce/)
 * (@just_bruce)
 * [21 years, 7 months ago](https://wordpress.org/support/topic/mysql-error-from-post2cat-table/#post-99882)
 * Well after a good night’s sleep i figured out how to fix it. It was a mysql db
   problem.
    One can use mysqlcheck –auto-repair _databasename_ to check all tables
   in a db and repair them. works for the 127 error. there were records hosed , 
   probably indexes, in the post2cat and the post tables. incidentally, use mysqldump-
   r _filename_ –opt _databasename_ to back up database content into a file that
   can be reloaded. the resulting file is just text and is easy to reload. use the-
   r switch in windows, not the –tab switch (which is for unix like systems). see
   mysql doc sec 8.6 (approx) for this! can tie off this thread now unless someone
   has other comments soon. I hope it is helpful to someone. A learning experience
   for me! Now I will schedule backups.

Viewing 1 replies (of 1 total)

The topic ‘mysql error from post2cat table’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 1 participant
 * Last reply from: [just_bruce](https://wordpress.org/support/users/just_bruce/)
 * Last activity: [21 years, 7 months ago](https://wordpress.org/support/topic/mysql-error-from-post2cat-table/#post-99882)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics