Title: Database table repair/optimization issue
Last modified: June 13, 2018

---

# Database table repair/optimization issue

 *  [rad-design](https://wordpress.org/support/users/rad-design/)
 * (@rad-design)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/database-table-repair-optimization-issue/)
 * Attempted to repair and optimize database before transferring a site to a new
   host. Received these errors:
 * wp_users: 2 clients are using or haven’t closed the table properly
    wp_comments:
   15 clients are using or haven’t closed the table properly wp_links: 1 client 
   is using or hasn’t closed the table properly wp_postmeta: 22 clients are using
   or haven’t closed the table properly wp_terms: 10 clients are using or haven’t
   closed the table properly wp_term_taxonomy: 16 clients are using or haven’t closed
   the table properly wp_term_relationships: 14 clients are using or haven’t closed
   the table properly wp_commentmeta: 10 clients are using or haven’t closed the
   table properly wp_yoast_seo_links: 17 clients are using or haven’t closed the
   table properly wp_yoast_seo_meta: 18 clients are using or haven’t closed the 
   table properly
 * Any thoughts?
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-table-repair-optimization-issue%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [7 years, 11 months ago](https://wordpress.org/support/topic/database-table-repair-optimization-issue/#post-10397589)
 * from phpmyadmin, select those tables and select “repair”.
 * see [https://www.siteground.com/tutorials/phpmyadmin/repair-optimize-database/](https://www.siteground.com/tutorials/phpmyadmin/repair-optimize-database/)

Viewing 1 replies (of 1 total)

The topic ‘Database table repair/optimization issue’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * Last activity: [7 years, 11 months ago](https://wordpress.org/support/topic/database-table-repair-optimization-issue/#post-10397589)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics