Title: Retrieve post text
Last modified: June 6, 2023

---

# Retrieve post text

 *  [axterx](https://wordpress.org/support/users/axterx/)
 * (@axterx)
 * [3 years ago](https://wordpress.org/support/topic/retrieve-post-text-2/)
 * Greetings to all wordpress users. Unfortunately I lost part of the text of a 
   post I was writing due to a sudden power outage that knocked out my router and
   PC. When I went to the site to Try to restore lost text but found no Auto save
   of all the work I had done that day, there were two revisions left from previous
   days.
   I searched the browser cache of the computer he was using but there is 
   nothing. I remember just before the blackout I did a preview of the post, but
   I don’t think this is relevant to the retrieval of the text.I thank all those
   who will want to give me some indications for a possible possibility of recovering
   the text that I have lost.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [3 years ago](https://wordpress.org/support/topic/retrieve-post-text-2/#post-16801568)
 * There should have been an autosave in such a situation, unless what you had lost
   was input between the last autosave interval and the outage. “all of the work”
   sounds like more than an autosave interval’s (every 60 secs IIRC) worth of work.
   It is possible to disable autosaves, but IMO there’s little reason to do so.
 * Anyway, if there is no autosave evident for the post, I’m sorry to say that the
   content is likely permanently lost. There is one “hail Mary” attempt for recovery
   you could try, but don’t get your hopes up. You can use the phpMyAdmin app to
   directly search for the lost content in raw DB data.
 * Identify the post’s ID. It’s visible in the editor screen’s URL. In the app (
   usually accessed through your hosting account) navigate to the wp_posts table.
   Click the Search tab. For the post_parent field, enter the post’s ID, then click
   the Go button. You’ll get a list of all revisions and any autosave that exist
   for the post. You can open any record in the list for editing so you can see 
   the actual post content. I recommend not actually editing anything here, look
   only.
 * If you do manage to find what you’re looking for, you can copy it from the edit
   screen back WP, but because it’s raw data, you’ll want to paste it into the post
   using the code view.
 * The phpMyAdmin edit screen has an annoying quirk. If you use your browser’s back
   button to try to return to the search results, it will not work, you’ll have 
   to redo the search. Instead, at the bottom of the edit screen, use the Go button
   to save and go back to the previous page. It’s OK to re-save if you haven’t changed
   anything. Or pick the Show insert query option instead of Save. Ignore the query,
   you’ll be able to see the search results as well.
 * Good luck in your search.
 *  Thread Starter [axterx](https://wordpress.org/support/users/axterx/)
 * (@axterx)
 * [3 years ago](https://wordpress.org/support/topic/retrieve-post-text-2/#post-16802573)
 * Thank you very much for the reply. I searched the SQL database but I only found
   two files that correspond to automatic saves but are empty. the hosting service
   offered me a backup for the day after I made the change for a fee ($50). I should
   understand how WordPress cancels autosaves, to know if the next day’s backup 
   can contain or not the text I’m missing…
 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [3 years ago](https://wordpress.org/support/topic/retrieve-post-text-2/#post-16804529)
 * AFAIK, autosaves are only removed when a post is updated (or deleted). An autosave
   should be triggered within 1 minute of any change. Unless what you’ve lost occurred
   less than a minute prior to the outage, I’m at a loss to explain why it’s missing.
   Perhaps there was some communications issue between you and your server, preventing
   autosave from working? Plausible since an outage was imminent. Some part of the
   infrastructure could have had power issues prior to you losing yours. Even if
   they have backup generators, it takes a while to re-stabilize after an outage.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Retrieve post text’ is closed to new replies.

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 3 replies
 * 2 participants
 * Last reply from: [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * Last activity: [3 years ago](https://wordpress.org/support/topic/retrieve-post-text-2/#post-16804529)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics