|
2014-11-10, 02:06 PM | #1 |
Oh! I haven't changed since high school and suddenly I am uncool
|
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, |
2014-11-14, 06:51 PM | #2 |
Certified Nice Person
|
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.
__________________
Click here to purchase a bridge I'm selling. |
2014-11-17, 04:49 PM | #3 |
Oh! I haven't changed since high school and suddenly I am uncool
|
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]# |
2014-11-17, 08:30 PM | #4 |
Certified Nice Person
|
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.
__________________
Click here to purchase a bridge I'm selling. |
2014-11-20, 12:03 PM | #5 | |
Oh! I haven't changed since high school and suddenly I am uncool
|
Quote:
|
|
2014-11-20, 09:44 PM | #6 | |
Oh! I haven't changed since high school and suddenly I am uncool
|
Quote:
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 |
|
|
|