I’ve compared my .sql file with the .sql file I dowloaded from the new installation to compare syntax and DID find a discrepency – just not sure what it means…
in the new sql file (exported from a fresh wordpress install) every single entry into a table structure has the following structure
INSERT INTO ‘wp_comment’ VALUE (values for comment);
INSERT INTO ‘wp_comment’ VALUE (values for comment);
INSERT INTO ‘wp_comment’ VALUE (values for comment);
INSERT INTO ‘wp_comment’ VALUE (values for comment);
instead of the way it is arranged in MY .sql file…(as exported – wp_comments as example)
INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES (values for comment),(values for comment),(values for comment),(values for comment),(values for comment),(values for comment);
INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES (values for comment),(values for comment),(values for comment),(values for comment),(values for comment),(values for comment);
above discrepancy between the files continues for all other table structure too… my version lists a (series of data types within parentheses) inbetween the INSERT INTO wp_whatever and the VALUE, but the one exported by the fresh wp install doesn’t… do I have to make my syntax match the newer file in order for it to work? It is alot of owrk and I don’t want to do that unless I have to.
(@heroesnhunks)
16 years, 9 months ago
I started a thread yesterday which put me on the right track to export my wordpress blog’s database as a sql file – but I’m having difficulty with applying it to my new host’s wordpress installation. They’ve been very helpful to a point but cannot help me figure out EXACTLY what the error is. They were able to determine that it happened at “line 55” because there was a duplicate line – line 55 appears to be the following …
INSERT INTO
wp_comments(comment_ID,comment_post_ID,comment_author,comment_author_email,comment_author_url,comment_author_IP,comment_date,comment_date_gmt,comment_content,comment_karma,comment_approved,comment_agent,comment_type,comment_parent,user_id)`
this code is followed by VALUES (values for comment), (values for next comment), etc
UNTIL one of the comments values is followed by a ; instead of a , and then the INSERT INFO code is repeated again…
…(value for comment),(value for comment);
INSERT INTO
wp_comments(comment_ID,comment_post_ID,comment_author,comment_author_email,comment_author_url,comment_author_IP,comment_date,comment_date_gmt,comment_content,comment_karma,comment_approved,comment_agent,comment_type,comment_parent,user_id) VALUEScould this be the problem that is stopping the sql database restore>
this code IS repeated a few timed within the data for table wp_comments. Should I go in and remove all but the first instance of
INSERT INTO
wp_comments(comment_ID,comment_post_ID,comment_author,comment_author_email,comment_author_url,comment_author_IP,comment_date,comment_date_gmt,comment_content,comment_karma,comment_approved,comment_agent,comment_type,comment_parent,user_id) VALUESand make sure the ; that preceded all the other instances become commas?