Title: Importing mySQL database error
Last modified: August 18, 2016

---

# Importing mySQL database error

 *  Resolved [Dap1](https://wordpress.org/support/users/dap1/)
 * (@dap1)
 * [19 years, 11 months ago](https://wordpress.org/support/topic/importing-mysql-database-error/)
 * I have recently switched hosts and I’m having trouble importing my WP database.
 * I have followed the tutorials on the forums, including:
    [ tamba2.org.uk/wordpress/restore](http://www.tamba2.org.uk/wordpress/restore/#one)
 * When importing the new mysql table content, I get the following error message:
 * #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 ‘CURRENT_TIMESTAMP
   on update CURRENT_TIMESTAMP,
    PRIMARY KEY

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

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [19 years, 11 months ago](https://wordpress.org/support/topic/importing-mysql-database-error/#post-405591)
 * Strange – I don’t recall seeing that particular error message before.
 * I can’t find that CURRENT_TIMESTAMP in my db so I’m assuming you have a plugin
   table inside the db?
    If so, does removing that table allow the import?
 *  Thread Starter [Dap1](https://wordpress.org/support/users/dap1/)
 * (@dap1)
 * [19 years, 11 months ago](https://wordpress.org/support/topic/importing-mysql-database-error/#post-405657)
 * Yes removing that table worked. Thanks

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

The topic ‘Importing mySQL database error’ is closed to new replies.

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 2 replies
 * 2 participants
 * Last reply from: [Dap1](https://wordpress.org/support/users/dap1/)
 * Last activity: [19 years, 11 months ago](https://wordpress.org/support/topic/importing-mysql-database-error/#post-405657)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics