Title: SQL Errors After Import From Back Up
Last modified: August 22, 2016

---

# SQL Errors After Import From Back Up

 *  [terrace_29](https://wordpress.org/support/users/terrace_29/)
 * (@terrace_29)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/sql-errors-after-import-from-back-up/)
 * I’m migrating sites to a new server, I’ve done a lot of transfers to this point
   but have not had these issues before. The problem have occurred on two different
   sites, I’m looking for solutions with respect to fixes, albeit in SQL, or options
   on other means of migration.
 * There are similarities between the two sites in terms of the errors themselves,
   I’m missing certain tables which are
    + wp_terms + wp_term_relationship + wp_term_taxonomy
   + wp_usermeta + wp_users
 * Below are my errors:
    [http://pastebin.com/yvKEfCif](http://pastebin.com/yvKEfCif)
 * Any insight or comments pointing me in the right direction would be greatly appreciated.

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

 *  [RossMitchell](https://wordpress.org/support/users/rossmitchell/)
 * (@rossmitchell)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/sql-errors-after-import-from-back-up/#post-5463779)
 * Are you sure that the database settings (database, username, password) are correct
   in your wp-config.php ?
 * Are you sure that the table prefix “wp_” is correct ? While this is the default
   value, it is also unusual to see it.
 *  Thread Starter [terrace_29](https://wordpress.org/support/users/terrace_29/)
 * (@terrace_29)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/sql-errors-after-import-from-back-up/#post-5463806)
 * Thanks for the reply Ross, yes I’m certain the info is correct, but I did notice
   the wp_. The other thing that strikes me as odd, statpress is a plug-in I don’t
   use, not certain why it is showing up.
 * I will look back into those issues you’ve mentioned, thanks.
 *  Thread Starter [terrace_29](https://wordpress.org/support/users/terrace_29/)
 * (@terrace_29)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/sql-errors-after-import-from-back-up/#post-5463861)
 * Still haven’t figured it out yet, I tried turning off the plugins on these particular
   site, as well as optimizing ahead of the back up then using that file.
 * Any thoughts?

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

The topic ‘SQL Errors After Import From Back Up’ is closed to new replies.

## Tags

 * [missing tables](https://wordpress.org/support/topic-tag/missing-tables/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [syntax errors](https://wordpress.org/support/topic-tag/syntax-errors/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 3 replies
 * 2 participants
 * Last reply from: [terrace_29](https://wordpress.org/support/users/terrace_29/)
 * Last activity: [11 years, 6 months ago](https://wordpress.org/support/topic/sql-errors-after-import-from-back-up/#post-5463861)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics