Title: Fixing WP table failed
Last modified: November 7, 2017

---

# Fixing WP table failed

 *  Resolved [srujanika](https://wordpress.org/support/users/srujanika/)
 * (@srujanika)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/fixing-wp-table-failed/)
 * Hello,
    I am developing a site on localhost (WAMP 3, MySQL 5.7.13) and tried 
   to repair/optise the installation before migrating to live server. Received the
   following error messages with suggestion to post on the forum for help (I sure
   need it bad!). Can someone please tell me what to do to fix the problems? Error
   Messages: (failed to repair table…) wp_usermeta: 10 clients are using or haven’t
   closed the table properly wp_posts: 9 clients are using or haven’t closed the
   table properly wp_options: 10 clients are using or haven’t closed the table properly
   wp_postmeta: 9 clients are using or haven’t closed the table properly wp_terms:
   2 clients are using or haven’t closed the table properly wp_term_taxonomy: 7 
   clients are using or haven’t closed the table properly wp_term_relationships:
   8 clients are using or haven’t closed the table properly Thanks, Nikhil
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ffixing-wp-table-failed%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [a2hostingrj](https://wordpress.org/support/users/a2hostingrj/)
 * (@a2hostingrj)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/fixing-wp-table-failed/#post-9661236)
 * How did you try to repair the table? Did you use the phpMyAdmin tool? or a WordPress
   plugin?
 *  Thread Starter [srujanika](https://wordpress.org/support/users/srujanika/)
 * (@srujanika)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/fixing-wp-table-failed/#post-9661877)
 * I first tried wp-repair (wp-admin/maint/repair.php) and got the report I posted.
   Then I tried phpMyadmin but could not solve the problem.
    After posting I searched
   some more and used WP-sweep/garbage collector plugins to get over the problem.
   Database tables from deleted plugins seems to be causing the problem. Appreciate
   your interest, still. Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Fixing WP table failed’ is closed to new replies.

## Tags

 * [repair](https://wordpress.org/support/topic-tag/repair/)
 * [table](https://wordpress.org/support/topic-tag/table/)
 * [WordPress-Database](https://wordpress.org/support/topic-tag/wordpress-database/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [srujanika](https://wordpress.org/support/users/srujanika/)
 * Last activity: [8 years, 7 months ago](https://wordpress.org/support/topic/fixing-wp-table-failed/#post-9661877)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics