Title: Database error
Last modified: August 21, 2016

---

# Database error

 *  [nippermh](https://wordpress.org/support/users/nippermh/)
 * (@nippermh)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/database-error-126/)
 * I have been trying to make a copy of my clients website on my local hard drive(
   XAMPP) because the live site is having issues. The live sites has auto generated
   posts in the blog section of the site from a slider and so I am trying to fix
   it by making a local install copy. When I try to make a local install copy I 
   get the following errors:
 * 765df_users: Table ‘hilsplace.765df_users’ doesn’t exist
    765df_usermeta: Table‘
   hilsplace.765df_usermeta’ doesn’t exist 765df_posts: Table ‘hilsplace.765df_posts’
   doesn’t exist 765df_links: Table ‘hilsplace.765df_links’ doesn’t exist 765df_options:
   Table ‘hilsplace.765df_options’ doesn’t exist 765df_postmeta: Table ‘hilsplace.
   765df_postmeta’ doesn’t exist 765df_terms: Table ‘hilsplace.765df_terms’ doesn’t
   exist 765df_term_taxonomy: Table ‘hilsplace.765df_term_taxonomy’ doesn’t exist
   765df_term_relationships: Table ‘hilsplace.765df_term_relationships’ doesn’t 
   exist

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

 *  [Keith](https://wordpress.org/support/users/keithdriscoll/)
 * (@keithdriscoll)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/database-error-126/#post-4303693)
 * Did you do a MySQL dump? You need to export the database and import it into your
   local MySQL. It looks like just about all of the default WordPress database tables
   don’t exist yet.
 * Even though you want to run local the procedures for moving WordPress from one
   server to another are essentially the same.
 * You can read more here: [http://codex.wordpress.org/Moving_WordPress](http://codex.wordpress.org/Moving_WordPress)
 *  [cecilh](https://wordpress.org/support/users/cecilh/)
 * (@cecilh)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/database-error-126/#post-4303703)
 * When i tried to log into my site wp-admin I got the message that the data base
   needs to be repaired.
 * I add the following line to the wp-config.php.
    define(‘WP_ALLOW_REPAIR’, true);
   When the page reloaded. I selected Repair and received the folloing result: wp_posts:
   1 client is using or hasn’t closed the table properly wp_options: Table is marked
   as crashed wp_postmeta: 1 client is using or hasn’t closed the table properly
   wp_terms: 1 client is using or hasn’t closed the table properly wp_term_taxonomy:
   1 client is using or hasn’t closed the table properly wp_term_relationships: 
   1 client is using or hasn’t closed the table properly wp_commentmeta: 1 client
   is using or hasn’t closed the table properly
 * Can anyone assist?
 *  [aloncarmel2k](https://wordpress.org/support/users/aloncarmel2k/)
 * (@aloncarmel2k)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/database-error-126/#post-4303717)
 * are the tables there?
 * did you try to repair them? are you able to query them using local mysql client?
 *  [cecilh](https://wordpress.org/support/users/cecilh/)
 * (@cecilh)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/database-error-126/#post-4303862)
 * Sorry for the delay.
    How do I query them using loc;
 *  [cecilh](https://wordpress.org/support/users/cecilh/)
 * (@cecilh)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/database-error-126/#post-4303863)
 * above should read local msql client
 *  [Keith](https://wordpress.org/support/users/keithdriscoll/)
 * (@keithdriscoll)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/database-error-126/#post-4303864)
 * Use phpMyAdmin.

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

The topic ‘Database error’ is closed to new replies.

## Tags

 * [sql-error](https://wordpress.org/support/topic-tag/sql-error/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 6 replies
 * 4 participants
 * Last reply from: [Keith](https://wordpress.org/support/users/keithdriscoll/)
 * Last activity: [12 years, 5 months ago](https://wordpress.org/support/topic/database-error-126/#post-4303864)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics