Dumping WP database content into Word? - Teh Forum

<body> <div id="header"> <span class="left"> <span class="back"><a href="lthread_list.php?webtag=DEFAULT"><span class="image mobile_back" title="Back"></span></a></span> <span class="image mobile_logo" title="Beehive Forum Logo"></span> </span> <ul> <li> <a class="reply_all" href="lpost.php?webtag=DEFAULT&reply_to=42382.0&return_msg=42382.1"> <span class="image mobile_reply_all"></span><span class="text">Reply to All</span> </a> </li> <li> <a class="navigation" href="#"> <span class="image mobile_navigation"></span><span class="text">Show messages</span> </a> </li> <li> <a class="main" href="#"><span class="image mobile_menu" title="Menu"></span> </a> </li> </ul> </div> <div class="menu main"> <ul> <li><a href="lthread_list.php?webtag=DEFAULT">Messages</a></li> <li><a href="lpm.php?webtag=DEFAULT">Inbox</a></li> <li><a href="lsearch.php?webtag=DEFAULT">Search</a></li> <li><a href="llogon.php?webtag=DEFAULT">Login</a></li> </ul> </div> <div class="menu navigation"><a href="lmessages.php?webtag=DEFAULT&msg=42382.1">1–7</a></div> <div id="page_content"> <h3 class="thread_title"><a href="index.php?webtag=DEFAULT&amp;msg=42382.1">Dumping WP database content into Word?</a> </h3> <div id="messages" data-navigation="42382_1_7_10"> <a name="a42382_1"></a><div class="message" id="message_42382_1"> <div class="message_header"> <div class="message_from"> From: Jo (JELLS)<span class="message_time"> 4 Jun 2019 13:11</span> <div class="clearer"></div> </div><div class="message_to">To: ALL<span class="message_count">1 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42382.1">42382.1</a></div> <div class="message_body"> Hello, long time no see, etc.<br /><br /> I had a WordPress blog (on my own webspace, not on wordpress.com) that broke badly in ways we couldn't figure out how to fix. I hadn't updated it with new content in over a year, and had been toying with the idea of taking it down anyway, but there was some content on the blog that I wanted to preserve. We've tried a clean install of WP and importing a back-up of the database, but it just results in the same brokenness -- so there's something in the database itself that is likely corrupt.<br /><br /> Anyway, I would like to know if there is a way to dump or export the content of the Posts table (wp_posts) to Word. I know there are some WP plugins that will do this now, but that's of no use to me because we can't get the database to work with a WP installation. All we can access is the database itself on our webspace -- through cpanel. Is there any way to get the posts content out of the database and into Word?</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42382.1&return_msg=42382.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42382.1"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42382_2"></a><div class="message" id="message_42382_2"> <div class="message_header"> <div class="message_from"> From: CHYRON (DSMITHHFX)<span class="message_time"> 4 Jun 2019 13:41</span> <div class="clearer"></div> </div><div class="message_to">To: Jo (JELLS) <span><span class="image post_read" title="Read: 4 Jun 2019 14:28"></span></span> <span class="message_count">2 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42382.2">42382.2</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42382.1#a42382_1" target="_self">42382.1</a></div> <div class="message_body"> WP hard codes paths into the database, which is usually the cause of breakage when trying to move or rebuild a WP site IME (assuming it's not a straight up password or hash issue). You can open the *.sql file into a text editor and do a global search & replace to fix the paths. This may or may not work, but it's usually pretty fast to try it out.<br /><br /> Do you have phpMyAdmin in cpanel? That's what I use to dump the db to a local file and re-import it.<div class="edit_text">EDITED: 4 Jun 2019 13:43 by DSMITHHFX</div> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42382.2&return_msg=42382.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42382.2"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42382_3"></a><div class="message" id="message_42382_3"> <div class="message_header"> <div class="message_from"> From: Jo (JELLS)<span class="message_time"> 4 Jun 2019 14:38</span> <div class="clearer"></div> </div><div class="message_to">To: CHYRON (DSMITHHFX) <span><span class="image post_read" title="Read: 4 Jun 2019 15:08"></span></span> <span class="message_count">3 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42382.3">42382.3</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42382.1#a42382_2" target="_self">42382.2</a></div> <div class="message_body"> <em>Do you have phpMyAdmin in cpanel? </em><br /><br /> Yes, we do.<br /><br /> I honestly don't understand anything else you said in your reply because I don't know anything about this stuff. I wouldn't have any clue what to do a search for or what to try to fix. I just want to see the content of my posts, so that I can copy paste the ones I want to keep into something else, maybe even another blog at some point. I realize that dumping the content of the post table would be just one big mess with no formatting and such, but I don't care -- as long as I'd be able to go through the content and find the ones worth keeping.<br /><br /> I don't know how to explain the broken part of what happened to the blog. I first noticed, after not having logged into it for months, that it wouldn't let me create new posts. As in, when I clicked on "New", no text box would appear for me to enter any content. I could enter a title, but there was no box for any text. I could edit existing posts just fine, but not create new ones.<br /><br /> Then the blog just stopped showing up. You'd go to the URL and get a page that said "Hmmm we're having trouble finding that site" (at least in Firefox). When we tried using the database backup on a clean install, it did the same thing -- as if there was no blog there at all.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42382.3&return_msg=42382.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42382.3"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42382_4"></a><div class="message" id="message_42382_4"> <div class="message_header"> <div class="message_from"> From: CHYRON (DSMITHHFX)<span class="message_time"> 4 Jun 2019 15:19</span> <div class="clearer"></div> </div><div class="message_to">To: Jo (JELLS) <span><span class="image post_read" title="Read: 4 Jun 2019 15:40"></span></span> <span class="message_count">4 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42382.4">42382.4</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42382.1#a42382_3" target="_self">42382.3</a></div> <div class="message_body"> Yeah there are several possible causes: there's a .htaccess that needs to be fixed because your hosting service changed paths around; WP update; WP update with incompatible plugins, somebody hacked it.<br /><br /> WP is notoriously insecure because it is so popular, and they attempt to beat this with frequent updates, but that creates its own set of problems. So people don't update it (this is less of a problem with WordPress hosting).<br /><br /> It's possible but somewhat less likely the db is corrupted.<br /><br /> Anyway, if you open phpMyAdmin, look for your database in the lefthand column, click on it, and then in the top menu of phpMyAdmin, click on "export", choose the defaults, and it will (probably) give you a stock web browser download dialog so you can save the file to your computer.<br /><br /> Then you can open it in any text editor (even Word) and sort through it to find your posts in plain text among a bunch of sql markup code.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42382.4&return_msg=42382.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42382.4"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42382_5"></a><div class="message" id="message_42382_5"> <div class="message_header"> <div class="message_from"> From: CHYRON (DSMITHHFX)<span class="message_time"> 4 Jun 2019 15:37</span> <div class="clearer"></div> </div><div class="message_to">To: Jo (JELLS) <span><span class="image post_read" title="Read: 4 Jun 2019 15:40"></span></span> <span class="message_count">5 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42382.5">42382.5</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42382.1#a42382_3" target="_self">42382.3</a></div> <div class="message_body"> This just occurred to me: "Hmmm we're having trouble finding that site," which doesn't sound like WP breakage per se (the other stuff you mentioned does) -- any chance the domain expired, or is pointing to the wrong ip address? Did you try talking to your hosting provider help folks?</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42382.5&return_msg=42382.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42382.5"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42382_6"></a><div class="message" id="message_42382_6"> <div class="message_header"> <div class="message_from"> From: Jo (JELLS)<span class="message_time"> 4 Jun 2019 15:42</span> <div class="clearer"></div> </div><div class="message_to">To: CHYRON (DSMITHHFX) <span><span class="image post_read" title="Read: 4 Jun 2019 15:45"></span></span> <span class="message_count">6 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42382.6">42382.6</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42382.1#a42382_5" target="_self">42382.5</a></div> <div class="message_body"> The domain has since expired, but at the time (last fall) it had not. And when we tried recently with a fresh install, it was on a sub-domain on my husband's site, so that wasn't the issue either.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42382.6&return_msg=42382.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42382.6"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42382_7"></a><div class="message" id="message_42382_7"> <div class="message_header"> <div class="message_from"> From: CHYRON (DSMITHHFX)<span class="message_time"> 4 Jun 2019 15:51</span> <div class="clearer"></div> </div><div class="message_to">To: Jo (JELLS) <span><span class="image post_read" title="Read: 4 Jun 2019 22:02"></span></span> <span class="message_count">7 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42382.7">42382.7</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42382.1#a42382_6" target="_self">42382.6</a></div> <div class="message_body"> Then it's very likely the hard-coded paths in the database are still pointing to the expired domain, so it can't find it. If you try to swap in the new domain by search and replace in the db .sql file, and then import it over the old db using phpMyAdmin, you might be able to get it up and running. You will also might need to take a look at the .htaccess file. It might be ok, unless it's got the old domain in it.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42382.7&return_msg=42382.1" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42382.7"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div></div> </div> </body>