bigbencomedy

SOLUTION:

In Text Wrangler, I did a replace all for “?post_type=blog-grind&” to “?” and another replace all for “blog-grind” to “post” , then I re-imported the database, copied wp_posts to my new wordpress install, and that seems to have imported the 80 or so most recent posts that I most wanted to restore that were previously not showing up.

The images don’t show up (cause I’m an idiot and didn’t save that folder) but the text is there and it works.

Thank you for all your help, I would’ve been lost without you. (It didn’t help that I didn’t setup the original site, so I guess there were additional blog names or something that was causing it to not import to the right spot)

Thank you David and Cukeving for the replies and suggestions. Sorry for the slow response, I was trying to follow all the suggestions. Here’s my follow ups:

Wordfence database scanner found no issues

I installed the Mac Version of Total Commander. It did not find any “base64” entries.

I then used Text Wrangler for Mac to open the sql database. It opened without being corrupt. I searched for “base64” it found one entry, which doesn’t seem like it applies:

<img alt="Constant Contact" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAARkAAAApCAMAAAA2w608AAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAwBQTFRFtsbaGEV8JlOM+89tUXanma7KJk98mq3FiKLDqLnOi6G5GUaA7Lhp+slcUXSgRGaN/ee2/NqOUnOZboyxhqDC/eCh/NR8fZax+9F12+LsGENyUnSd+Mtxt8TWJlOR8LhYQ2qe66AhNF6VQ2eR+spg7Lx3i6LAiqLEHURyg57AvcvdYICpNVyNi6PC8qod9a4b8agd/vTe7KMf5psjb4qpJlGFk6rI+LEa/u7M/eKp/eq+NF+Y/NyV+8xn97Aa/d+dboy0tsXYxdDc6Z4hqLjK5Jkk99us7bVZ/vDTbouuNF2R+cVT1Nzm1d7qUXWk+9Bx1Nzkt8TUYH+ljqG5t8TSYH6eK1B8+sZVNVuFYIGvdZK4YH6g/evD+ujHqLrRpbnRYIGsma7I4ZUlmqzC/evGcIyui6K++LUocYupJlCAnrPN/eStHEV1+Nec6qxN+taN+9aDssPY9sBVfZe5Q2iWGUeE/vLZ/e3JKFKF/ei6/N2bNVuJxtDdx9Db9M+QnK3BjqG3Q2mZF0iIF0eHF0eGF0eFGEN1F0aDF0aBGER5F0V/GEN2GER6F0eEGER4qLrT093pF0V+i6PExdHibo22xdHhF0eIF0aCF0aAUnGVGER3GEV7fZi9ma/MxdHg76YeQ2qggJu/9KwcG0V4GkZ+iqTEUnKWF0Z/09zoqLrSG0V6fZi8fZm9xdDexdHf55wii6K9G0Z709znfZi7GkZ8eZW7/d2Y/NeFe5i8+shZ+sdY7aMf8KcefZe3xdDf+9iMi6G8+bw2qLnQtsXaws/ggZatxNHh/u/Q/NWAqLvT6bBc+stj/NR+8MqS+OXIxtLitMTZw9Dh9+C6VnOU1Nvk8a0rwc7fsMHWb4mnUXWmGEiH+9ub9+TJ/O7Vr8HW/vXgj6fG/N6b4OfvuMTSjKPAxtHe+cBEOVuDOFyJcIyw78B2/ezF9tGPfZWv7agu8c+gVnKT5aJA5qdP561cmq/L+uvW+uzW/NiKUnWj/OOs67Jb+MJUF0iJF0iK///gFBQU3oCw6gAAAQB0Uk5T////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////AFP3ByUAAAqDSURBVHja7JoJdJTVFcc/w4QYtAFZGiRkGpOQImSKVALKQCUQRGAMBQwQERo2CwguLIqioiQggjLTWdrGZmKkhCakoRRbCrUsiooL3fe92t2W7gu25B/fvfd73zKZnIRU23PSvHMc37zv3ve/7/fuu28yg9Ha06wGaovWPvjGv175K4weHjaUHw5dd9WTz1wx5eqpS4f1kDGxBLb86YVrR+15nyaD1h4yCkv2ynlrhs/Dh20yw3rItKJ4xab9n1wzfPhDJz5gk0Hr/z0Z/OKSvZ8jMiplbDJv9JBpxUaTzNwT42wy/2hLBv+L4N6526Zjo3OaDJ61yUwjR8N9b4U6Nd/be1dG3hFNBD2e8o6mRWybSWblteM0mfdM+4aTDBD3eFuo1dXgv8YlWO4XzejbrYlIeZ2nxtPBtMjVZO4/c+K+5ctpjy5/XfbJMGOMttjtQtF0esddhkDYa2t60KkM67QMwmiJlicHbk2Dxh8oMoUr0u5XQGJG4+qBVz716c/f/CGbDIKOGFtaDFzYgYh3asdBKQLHpvqdmmF07B8Kh9EpGRUPwqEWTzBZYMCZe8xh+HMnLQb6TRjcz6ivr7/4YiEjT4mMK2FaWvwXBKZGLbCuMxser1Nzwy4DLs2WjsFEvZ3iFzRlUBcN1bUtNMCb889YORPCLffNyn/XF+djrE1moEVGg/EEVS2MBMvjF0SGPDuTM3CdGQ3GH1eaISPa4Qzi0HE2w2/urSo0nrYgcfeso/Ohk2v8a+8e3GuiIvPPy+ttMndpMjAkxggfY/OegDT7AtFD9ogMsrNmCceDBCeEnBUMIT6+3mB7mq2Jmqghh1BbIed7vQHlaOfWxj0T848OkomfN3DZF0wy4w0HGdNLkfGeVy3HOQ1dVKrVRFjBCIfDERmKhmSVNfzYUPOHKRIN1eBxT41acEQ5BcWpnK9l3vOgXqeHNL0hl2YwSsZBWaByD6tZaEhxV24ePnMmQlvI4apSRHlI0WqnVmPWxPxXabrXf3Lk5oZ+Fhk+TCaZ92oyCHOQrhitukPwOaawrtEqn1GuH0fswh1yXTUedirXTkFHUQlyppHm+ZhTNK69/YqXLFBoUBnzWO5eJAipcGusMm5F1pK0JGCCIvMm0LD6yqeODMRhTeZOPkwmma9ZZDhlgo5LI+S4qFRtBb31OiKrs/qyQCEb8rtuGjKyDUOW4XlYKeOsLc5LQKUS4i1O0XCN5V7uFqqBM9yILRNKditdc2bWxNcQihOBIyNOW2T6jXCQuVGTMbaq5ryO4HXfpnBfIkbY6kajViDRUMK973YKWoY5TIY0t7YDhgqonQayP/YWBN1CcScYvy3jT54yZyYAMYWAyOA2i8xPR7xsxGIvvvj157/z3dXa02j6qGpNjpSpk3Qwz5RXElsdjYjBMYRpy7xUOuIh/1bd4lZFZS+ptyrZI4ZfnCxDOkyNpJnj0IzrXYibJ06OjzcYEWQh7e61S3eNVDgBEzUikXiwworHlyxlbrlu9Ff+QiWFyIzFoMOXTRh07w13w920uVFaqVqx43OGVRvh52IQl6Sg800dfvHo4u+jNcaAHF3FpSezsBO7h3GKDFPNCuojTUfwcqIZWlj8zptRQHrA98mfCrElxD1w2npjelkxMvMlL8A4jUunDgvVC5mvjj4N/Pj6B6fdvvTSpOXaSKmsqqqya6Hg4LIDPt3xqEYhUcua4+YdU0FrhIDgDIZYN+kBNAoZhmHKoFRJVqXamnGbdky6VoWGTARvVWVlKeSx1xLKgbuUI9W9z24ya/8w5eq//43I/OyuG7H8jnVXPfn+Kz4zdekfk5PZRs0OMmSXHfg4L3PolYNs4p6H09XP0SBHLTFXpQwNNZJNjHpN8FgDPIkhMPSnkVLSrLVFc8SmVZcgzyl+tUqSByD3p+GYlwONckh2Kcckh0wimHVfembK7aivH6sqxZaHbhg3ao9J5kfJyTxOrcENvckkQ30eyOUg+eChoVIaGYGWWAHYNmzeyFssW2tmVa4yzLHIkOZz9nrIRD43IEb9Up/Mot/7UExCi9sIpebQa4OD8ePbtqUkPUr49x5F5vpTL4eQ1nf48BdO2GSSkzRSPqaalX/wEXR5K/vsk92i9ymSIKfo/3wcUEtL9GGxbVNB3Qbe4goeyK2qqkwByHCAJpNBmustzRhZl4omTzXJyjCJZzF8sn/FCULs6cgRlilFEi4ly0cRGeDAis/St74P/Moi8+d2yGTsUG2AFaUj0TkhtqWS2GJo2Qr6aDWJn6j1LqEl1sJHbxmn+KBYiNmx1pLhEk2mgDRnWJq15PO0Wbg4OVKUk6TGAEEykvwhQqkOIXqxSeAQmRW0/aMg8OsHZo7a8+3fI5Z7yV4mg3EWmVfaIXPsU9QO6aAHPKIak0EBdUeu1wMoph7LovYRGR1AS4TtJL0MceUBtlwvLA5okWLWtECxzUghwxM3WAN4mLrADOX+MBzzcm+GmNtk0kmmTQFG+pq+qqwMVVdWxUYh883f2WS+3A6ZQx+hVhigm079x0ugRMch6u2ozfi4akKKegfk3s2QlWbsVA0CSC0UxeyTgZGW0xLqPYc5bKi/8kURaRY1m5qslCIgOIMPkJPsAfUyAHLPMKNTD3DAFNphEee/3ArI7njCnY20/WtKZs1kgyqTzNwTHZNB1kXcpmcH0Jx9MI3m3pkOHC+SaGgNG1g6i7qYU0yfGwoFSRF5NktAhUAa++wsQCEtnJ2mk9MhEUlDwLy2D4pmVnozaQZ4tulqWgZYhFvJibYex6l3DM1krQQK5DnSRegYNvCAChfp0xUwljmoZTSZTfvnoR9H06jJ/Hz+szOH3rF20aJF7X5RqP7WXvWYo6UXcsyFG/h/RQh8QrXpPG2h6hWqGIuysphIFiA+c7IvcrWDIKcsdtpAXaC/WK7SSZPn1Bxzq4iZe5SOOezE2029dDSLYVogUSjd8U6RMWUec32rOnLv/rnmx68ok/nNyi1tP/ImIxNY9YTdNmc/ardVAWTvVu0kR0m9/iedD7GQxnbnYbMezKOXk5MTnIAxbKh6Otw8h+YTgTyHqEqAPGXKEJFJXpPB0+x+NBP93ULK1HZUZE6KzGbnn2S1Gzf90vp2syrlt+md/KmCvtND/+12W5bee5fZ1IrQh8YmU2JPpl6fhfqhAmOObd+u4MpgHui1DzvNtpwylWXvXdRbaBfLTIfmQuTpaRdkK2MaY4gSGbT1gkQhShPtuYv0RKa/k8y5c3KU+FN9Q+d/wJFvyANn+w6hVn12tnLNpDcLxjCPPtXV1WUc5E2qV/1BZO4jw33LpBJPZlPlNKb3kCF9S4B9qs0uIVN+/i3q3aQWEChThr1LHB89sKyaNft+T42ihKbtXVbCdZKc2BRlqneW41hAprCFykiInpSU8SwSrsj0ccgEfaN7XYcL/ZXD8auK89w5j2DiV5ytaPOlpOt7yYQDnDhnm5/hkmm2JuklGLZ54n7j+gv71fmju/JrVnf/XRu35R/N79LPfEZ3B9Mr/+iEHjJJyLzUK//Orv0y3L3JYPxLg+/t4k/m3ZzM4UFd/mcW3ZoMRl/T9X9j0c1z5j/4xydvCTAA95hdN8HdFIAAAAAASUVORK5CYII=" width="250" height="36" /></a>

I’m looking at line by line entries of what wordpress read and what it didn’t and I can’t see the difference.

DB line that is recognized by wordpress as a post entry:
(1994, 2, '2015-08-24 19:14:42', '2015-08-24 23:14:42', '[embed]https://youtu.be/1rOi-y6Bqsg[/embed]', 'Michelle Slonim Stand up Chicago', '', 'publish', 'open', 'closed', '', 'michelle-slonim-standup', '', '', '2015-08-24 19:15:22', '2015-08-24 23:15:22', '', 0, 'http://michelleslonim.net/?p=1994', 0, 'post', '', 0),

DB Line that is not recognized by wordpress as a post entry:
(1998, 2, '2015-09-01 12:00:57', '2015-09-01 16:00:57', '<p class="p2"><img class="aligncenter wp-image-1999" src="http://michelleslonim.net/wp-content/uploads/2015/09/5-Problems-with-Preliminary-Notices-219x300.jpg" alt="3D ZAHL 5" width="96" height="132" /></p>\r\n<p class="p2">I did 5 sets in one night and I was neither inspired or excited, in fact I was bored. This seems like the wrong feeling since as comedians  we are constantly looking for more stage time and more opportunities. Finally I was given that stage time and I didn''t even appreciate it. I think it means I need new material.</p>', '5 Sets in One Night', '', 'publish', 'open', 'closed', '', '5-sets-in-one-night', '', '', '2015-09-01 11:52:12', '2015-09-01 15:52:12', '', 0, 'http://michelleslonim.net/?post_type=blog-grind&p=1998', 0, 'blog-grind', '', 0),

I did not download bew copies of all plugins and themes.

Disabling all plugins and going to standard theme didn’t make a difference.

And I didn’t download the uploads and images folder. Basically the site was slow and hacked files and BlueHost was not at all helpful, so I just got the db exported and had them delete all public_html files and subfolders.

I don’t care about getting the images back, I just want to be able to import the blog text from old blog posts into my new site. I only imported wp_posts into my new db cause I don’t care about the rest.

I did basic phpMyAdmin of analyze and fix tables. It seemed fine.

Ok I understand about the not 1200 actual posts. My guess is the real number of unique posts is closer to 200-400.

Either way, I’m positive that not all entries have been restored (see the two screen shots in my previous post).

Is there a database error that I could fix to get it to re-read the posts that are in there but not showing up? Any other ideas? I’ve managed to export the sql file as an html file, so I can see all the text on all the blog posts… Not sure if that helps at all?

Thank you

I’m not sure what “confirming by other means” would entail?

When I click onto “edit” in phpmyadmin it seems to display text consistent with the post.

Here is the PhPmyAdmin screenshot: http://i.imgur.com/Sh7I4Vi.png

And the wordpress posts listing: http://i.imgur.com/QXrjDBW.png

Both are sorted by date (most recent first).

Post_title slump and blinders are examples of posts that don’t show up in wordpress but are in the database (not sure why there are post_titles that are the same)

Where would I go to make sure I’m using full feeds? I know I use feedburner for the RSS feed…

Thanks again for all your help!