• I am trying to import my .sql file using PHPMYadmin to my SQL server and I am getting the following error:

    SQL query:

    INSERT INTO wp_posts VALUES (1307,2,’2012-02-03 15:08:33′,’2012-02-03 20:08:33′,”,’quizzo’,”,’inherit’,’closed’,’open’,”,’quizzo’,”,”,’2012-02-03 15:08:33′,’2012-02-03 20:08:33′,”,1306,’http://summitphilly.com/wordpress/wp-content/uploads/2012/02/quizzo.jpg’,0,’attachment’,’image/jpeg’,0),(1290,2,’2012-02-03 14:51:17′,’2012-02-03 19:51:17′,”,’02-03-2012′,”,’inherit’,’closed’,’open’,”,’1289-revision’,”,”,’2012-02-03 14:51:17′,’2012-02-03 19:51:17′,”,1289,’http://summitphilly.com/uncategorized/1289-revision/’,0,’revision’,”,0),(373,1,’2011-03-15 08:14:05′,’2011-03-15 15:14:05′,”,’Blog’,”,’inherit’,’closed’,’open’,”,’347-revision-3′,”,”,’2011-03-15 08:14:05′,’2011-03-15 15:14:05′,”,347,’http://summitphilly.com/wordpress/347-revision-3/’,0,’revision’,”,0),(1405,2,’2012-02-03 17:00:43′,’2012-02-03 22:00:43′,’Yuengs\’ and Wings features everybody\’s favorite local beer, and our mouth-watering wings. $1 Yuenglings and 3 wings for $1.’,’02-27-2012′,”,’publish’,’closed[…]

    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 ”Become part of the lifestyle and social scene of Summit Park. Quality services,’ at line 1

    I am not very familiar with MYSQL or PHPMyAdmin imports and really have no idea what I need to do to fix this issue or what caused it. I am not able to import any pages or blog posts and I am desperate for any help I can get. Is this .sql file corrupted and useless or are there edits I can make to it so it can import correctly??

The topic ‘SQL Query when importing to PHPMyAdmin’ is closed to new replies.