SQL Error Help - Migration
 

I've been transferring some site from server to server, of the bulk I've done I'm at 80% success, there's two pesky DB's that are giving me errors, importing from back up sql files

My error code is here: http://pastebin.com/yvKEfCif

I've tried it with plugins disabled, but to know avail. The wp_statpress for example is related to one of the plugins, my security plug in I think. I didn't have to turn off the plugins on all the sites, but I'm guessing that going into the existing table on the new server and editing, modifying, adding, subtracting, repairing the tables will solve my ills, I just am not clear on the procedure.

Hopefully someone here can either give me insight into the correct fix, or point me in the right direction for the solution.

Much appreciated,

It's impossible for me to say without seeing the lines that caused the error. Sometimes it's a matter of a comma or apostrophe missing, or the piece of data within the apostrophes contains characters that anger mySQL.

Thanks for the reply UW, it's returning syntax related errors. I'll try to provide better examples as I'm really looking to have this fixed versus scrapping it.

Here was the last error message: (I've replaced my root directory with 'user' just for posting purposes)

root@q3 [/home/user]# mysql user_wp11 < user_wp1.sql
ERROR 1064 (42000) at line 19180: 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 '(12645, 20130324, '02:27:19', '86.151.37.157', '/danni-daniels/', 'Mozilla/5.0 (' at line 121
root@q3 [/home/user]#

It would be most helpful to see the the line before for the error-causing line (12645), the error-causing line, and the line after it for comparison reasons.

It is possible that the line which angers mySQL was fine when it was originally added to the table, but an updated of mySQL version may no longer tolerate something within it.

That is my thinking, I have to pull out those strings and take a look, I will post them. It is certainly syntax related, I have gotten behind with but definitely need to repair it. I appreciate your input, will get back shortly.

12644 (6022, 20130308, '00:23:36', '64.6.101.67', '/wp-content/uploads/2013/03/sheeba/sheeba_starr_pic3/2.jpg', 'WordPress/3.5.1; http://strokingqueens.com', '', '', '', '', '', '', 'WordPress', '', '', '2013-03-08 08:23:36'),

12645 (6023, 20130308, '00:23:36', '64.6.101.67', '/wp-content/uploads/2013/03/sheeba/3.jpg', 'WordPress/3.5.1; http://strokingqueens.com', '', '', '', '', '', '', 'WordPress', '', '', '2013-03-08 08:23:36'),

12646 (6024, 20130308, '00:23:36', '67.101.133.165', '/wp-content/uploads/2013/03/sheeba/3.jpg', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0 SeaMonkey/2.16', 'http://strokingqueens.com/sheeba-starr/', '', 'en', 'Windows 7', 'Firefox 19', '', '', '', '', '2013-03-08 08:23:36'),

Here are the three lines successively, I don't know well enough to see any difference or where the error is related