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_messagesCREATE TABLE
wp_09vwg62cy4_bp_messages_messages(
idbigint(20) NOT NULL AUTO_INCREMENT,
thread_idbigint(20) NOT NULL,
sender_idbigint(20) NOT NULL,
subjectvarchar(200) NOT NULL,
messagelongtext NOT NULL,
date_sentdatetime NOT NULL,
PRIMARY KEY (id),
KEYsender_id(sender_id),
KEYthread_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_messagesVALUES(37, 11, 1, ‘Re: user pay’ at line 2
Here is the line of it.INSERT INTO
wp_09vwg62cy4_bp_messages_messagesVALUES(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.
The topic ‘mysql import syntax errors’ is closed to new replies.