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
(
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
),
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_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.
- The topic ‘mysql import syntax errors’ is closed to new replies.