Title: mysql import syntax errors
Last modified: September 1, 2016

---

# mysql import syntax errors

 *  [Omtesla](https://wordpress.org/support/users/itesla/)
 * (@itesla)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/mysql-import-syntax-errors/)
 * Hello
    Sorry if i post here but i’m trying to move from godaddy managed wp to
   dreamhost shared hosting and i get syntax errors at different points. Can someone
   look and tell me where is the error? At the moment i have errors in wp_bp_messages_messages
 * > CREATE TABLE `wp_09vwg62cy4_bp_messages_messages` (
   >  `id` bigint(20) NOT NULL
   > AUTO_INCREMENT, `thread_id` bigint(20) NOT NULL, `sender_id` bigint(20) NOT
   > NULL, `subject` varchar(200) NOT NULL, `message` longtext NOT NULL, `date_sent`
   > datetime NOT NULL, PRIMARY KEY (`id`), KEY `sender_id` (`sender_id`), KEY `
   > thread_id` (`thread_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT
   > =1912 ;
 * This is the error it say i have chk using MySQL workbench but not see any error
   at that line.
 * Error
    MySQL said: Documentation
 * #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 ‘INSERT INTO `wp_09vwg62cy4_bp_messages_messages`
   VALUES(37, 11, 1, ‘Re: user pay’ at line 2
    Here is the line of it.
 * > INSERT INTO `wp_09vwg62cy4_bp_messages_messages` VALUES(37, 11, 1, ‘Re: user
   > payd’, ‘he have to check the paypal email for activation. sorry i was busy 
   > studying. ‘, ‘2012-10-30 01:17:36’);
 * I can’t post more data because is from private messages.
    Any input are welcome
   to help,unfortunately both hosts don’t care much to help.

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

 *  [Alfonso Catrón](https://wordpress.org/support/users/alfonso100/)
 * (@alfonso100)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/mysql-import-syntax-errors/#post-7481296)
 * Hi iTesla,
    I’ve tested this in local mode and it works just fine.
 * I think it might be a character encoding issue.
    This post might help you [https://wordpress.org/support/topic/encoding-errors-migrating-a-database-from-one-host-to-another?replies=6](https://wordpress.org/support/topic/encoding-errors-migrating-a-database-from-one-host-to-another?replies=6)
 * And this answer might solve your issue:
    [https://wordpress.org/support/topic/wp2-accented-characters-changing?replies=10#post-303707](https://wordpress.org/support/topic/wp2-accented-characters-changing?replies=10#post-303707)
 * good luck!
 *  Thread Starter [Omtesla](https://wordpress.org/support/users/itesla/)
 * (@itesla)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/mysql-import-syntax-errors/#post-7481335)
 * Hello alfonso100
    Unfortunately i canceled account at dreamhost can’t test anymore
   but i will keep in my mind for future. Thanks for helping!

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

The topic ‘mysql import syntax errors’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [Omtesla](https://wordpress.org/support/users/itesla/)
 * Last activity: [9 years, 11 months ago](https://wordpress.org/support/topic/mysql-import-syntax-errors/#post-7481335)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics