Title: Problem moving WP database to new server
Last modified: August 18, 2016

---

# Problem moving WP database to new server

 *  [gunnerblog](https://wordpress.org/support/users/gunnerblog/)
 * (@gunnerblog)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wp-database-to-new-server/)
 * I’m moving my site from one server to another. I’ve created the account on the
   new server but I can’t restore the database.
 * The error I get is:
 * #1064 – You have an error in your SQL syntax. Check the manual that corresponds
   to your MySQL server version for the right syntax to use near ‘collate latin1_general_ci
   NOT NULL,
    `value` text collate lati
 * —
 * I assume this means that this means there’s a difference between the version 
   of MySQL on my old server, and on the new one. Is this correct?
 * And if so, how can I go about restoring the database?
 * Any help greatly appreciated.

Viewing 1 replies (of 1 total)

 *  [Chris_K](https://wordpress.org/support/users/handysolo/)
 * (@handysolo)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wp-database-to-new-server/#post-446829)
 * Have a look at this thread: [http://wordpress.org/support/topic/56497?replies=7#post-368363](http://wordpress.org/support/topic/56497?replies=7#post-368363)

Viewing 1 replies (of 1 total)

The topic ‘Problem moving WP database to new server’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Chris_K](https://wordpress.org/support/users/handysolo/)
 * Last activity: [19 years, 8 months ago](https://wordpress.org/support/topic/problem-moving-wp-database-to-new-server/#post-446829)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics