CSV Import problems

I’m trying to do a CSV import of my directory listings. I have exported a sample CSV file and copy and pasted my information under the appropriate headers. If I just download the sample file and upload it back it works. As soon as I start adding my copy to it then I get an database error message below saying the table doesn’t exist.

WordPress database error: [Table ‘agreso5_wp588.temp_21_07_2016_19_48_06’ doesn’t exist]
LOAD DATA LOCAL INFILE ‘/home/agreso5/public_html/resourcedirectory/wp-content/uploads/2016/07/CSV-Tuesday 12th of July 2016 08-37-53 PM .csv’ INTO TABLE temp_21_07_2016_19_48_06 CHARACTER SET UTF8 FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘\”‘ ESCAPED BY ‘\\’ IGNORE 1 LINES (ID,post_author,post_date,post_content,post_title,post_excerpt,post_type,category,phone,url,image,featured,listing_status_msg,listing_sticker,packageID,topcategory,html,visitorcounter,showgooglemap,listing_expiry_date,map_location,map-log,map-lat,map-country,map-address1,map-address2,map-address3,map-zip,map-state,map-city,access,timeaccess,hits,Contact Name,key_email,post_id 21,1,7/12/16 4:01,Auto Draft,listing_type,21 23,1,7/12/16 4:34,Auto Draft,listing_type,23 17,1,7/10/16 3:56,Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tempus eleifend risus ut congue. Pellentesque nec lacus elit. Pellentesque convallis nisi ac augue pharetra eu tristique neque consequat. Mauris ornare tempor nulla, vel sagittis diam convallis eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tempus eleifend risus ut congue. Pellentesque nec lacus elit. Pellentesque convallis nisi ac augue pharetra eu tristique neque consequat. Mauris ornare tempor nulla, vel sagittis diam convallis eget. <blockquote>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer posuere erat a ante. <small>Someone famous <cite title="Source Title">Source Title</cite></small></blockquote> Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tempus eleifend risus ut congue. Pellentesque nec lacus elit. Pellentesque convallis nisi ac augue pharetra eu tristique neque consequat. Mauris ornare tempor nulla, vel sagittis diam convallis eget. <dl class="dl-horizontal"> <dt>Description lists</dt> <dd>A description list is perfect for defining terms.</dd> <dt>Euismod</dt> <dd>Vestibulum id ligula porta felis euismod semper eget lacinia odio sem nec elit.</dd> <dd>Donec id elit non mi porta gravida at eget metus.</dd> <dt>Malesuada porta</dt> <dd>Etiam porta sem malesuada magna mollis euismod.</dd> <dt>Felis euismod semper eget lacinia</dt> <dd>Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus.</dd> </dl>,Example Listing 6,listing_type,123-444-555-6666,https://premiumpress.com,https://agresourcedirectory.com/resourcedirectory/wp-content/themes/BT/framework/img/demo/noimage.png,no,0,no,no,no,no,a:1:{i:0;s:2:"99";},a:6:{i:99;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:100;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:0;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:1;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:2;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:3;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}},2,17 24,1,7/12/16 18:31,<h3><strong>Physical Address:</strong></h3> <p style="padding-left: 30px;">1300 W. Locust, Springfield, MO 65803</p> <h3><strong>Products & Services Offered:</strong></h3> <ul> <li>Medicated Feed</li> </ul>,ADM Animal Nutrition,listing_type,Animal Health,1-800-492-4881,www.admani.com,no,0,no,yes,no,yes,7/12/17 13:23,a:1:{i:0;s:2:"99";},a:6:{i:99;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:100;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:0;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:1;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:2;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:3;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}},9,Eric Tietze,eric@ozarksfn.com,24 100,1,7/12/16 18:31,ADM Animal Nutrition,listing_type,Animal Health,1-800-492-4881,www.admani.com,no,0,no,yes,no,yes,7/12/17 13:23,a:1:{i:0;s:2:"99";},a:6:{i:99;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:100;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:0;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:1;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:2;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:3;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}},9,100 101,1,7/12/16 18:31,Callicrate Banders,listing_type,Animal Health,1-800-858-5974,www.callicratebanders.com,no,0,no,yes,no,yes,7/12/17 13:23,a:1:{i:0;s:2:"99";},a:6:{i:99;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:100;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:0;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:1;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:2;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}i:3;a:2:{s:4:"time";s:0:"";s:4:"link";s:0:"";}},9,Rachel Dodd,rachel@nobull.net,101)

string(4690) “LOAD DATA LOCAL INFILE ‘/home/agreso5/public_html/resourcedirectory/wp-content/uploads/2016/07/CSV-Tuesday 12th of July 2016 08-37-53 PM .csv’ INTO TABLE temp_21_07_2016_19_48_06 CHARACTER SET UTF8 FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘\”‘ ESCAPED BY ‘\\’ IGNORE 1 LINES (ID,post_author,post_date,post_content,post_title,post_excerpt,post_type,category,phone,url,image,featured,listing_status_msg,listing_sticker,packageID,topcategory,html,visitorcounter,showgooglemap,listing_expiry_date,map_location,map-log,map-lat,map-country,map-address1,map-address2,map-address3,map-zip,map-state,map-city,access,timeaccess,hits,Contact Name,key_email,post_id 21,1,7/12/16 4:01,Auto Draft,listing_type,21 23,1,7/12/16 4:34,Auto Draft,listing_type,23 17,1,7/10/16 3:56,`Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tempus eleifend risus ut congue. Pellentesque nec lacus elit. Pellentesque convallis nisi ac augue pharetra eu tristique neque consequat. Mauris ornare tempor nulla, vel sagittis diam convallis eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tempus eleifend risus ut congue. Pellentesque nec lacus elit. Pellentesque convallis nisi ac augue pharetra eu tristique neque consequat. Mauris ornare tempor nulla, vel sagittis diam convallis eget.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer posuere erat a ante. Someone famous Source Title
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tempus eleifend risus ut congue. Pellentesque nec lacus elit. Pellentesque convallis nisi ac augue pharetra eu tristique neque consequat. Mauris ornare tempor nulla, vel sagittis diam convallis eget.
Description lists
A description list is perfect for defining terms.
Euismod
Vestibulum id ligula porta felis euismod semper eget lacinia odio sem nec elit.
Donec id elit non mi porta gravida at eget metus.
Malesuada porta
Etiam porta sem malesuada magna mollis euismod.
Felis euismod semper eget lacinia
Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus.
,Example Listing 6,listing_type,123-444-555-6666,https://premiumpress.com,https://agresourcedirectory.com/resourcedirectory/wp-content/themes/BT/framework/img/demo/noimage.png,no,0,no,no,no,no,a:1:{i:0;s:2:”99″;},a:6:{i:99;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:100;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:0;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:1;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:2;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:3;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}},2,17 24,1,7/12/16 18:31,
Physical Address:

1300 W. Locust, Springfield, MO 65803

Products & Services Offered:

Medicated Feed
,ADM Animal Nutrition,listing_type,Animal Health,1-800-492-4881,http://www.admani.com,no,0,no,yes,no,yes,7/12/17 13:23,a:1:{i:0;s:2:”99″;},a:6:{i:99;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:100;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:0;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:1;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:2;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:3;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}},9,Eric Tietze,eric@ozarksfn.com,24 100,1,7/12/16 18:31,ADM Animal Nutrition,listing_type,Animal Health,1-800-492-4881,http://www.admani.com,no,0,no,yes,no,yes,7/12/17 13:23,a:1:{i:0;s:2:”99″;},a:6:{i:99;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:100;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:0;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:1;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:2;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:3;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}},9,100 101,1,7/12/16 18:31,Callicrate Banders,listing_type,Animal Health,1-800-858-5974,http://www.callicratebanders.com,no,0,no,yes,no,yes,7/12/17 13:23,a:1:{i:0;s:2:”99″;},a:6:{i:99;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:100;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:0;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:1;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:2;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}i:3;a:2:{s:4:”time”;s:0:””;s:4:”link”;s:0:””;}},9,Rachel Dodd,rachel@nobull.net,101`)” NULL error=,