Lost content (9 posts)

  1. carrollw
    Posted 3 years ago #

    Hi everyone...

    I have a problem I don't know how to fix.

    At least I hope I can fix it.

    I deleted one article from my blog, but when I pulled up all my articles they were all deleted. I had over 100 articles written.

    Right now it show ZERO articles.

    Is there a way to reload all my deleted articles????

    All help is greatly appreciated.


  2. cubecolour
    Posted 3 years ago #

    do you have a database backup?
    can you see any posts listed in 'trash'

  3. carrollw
    Posted 3 years ago #

    I thought I did, but I didn't have is set up properly.

    I don't see a trash bin for posts, or anything else.

  4. cubecolour
    Posted 3 years ago #

    if you go into posts from the dashboard, at the top of the lists of posts, you should have links labelled: all | published | draft | trash with the number of posts in each listed. If the trash is empty, that link will not appear.

    What version of WordPress are you using?

    Can you connect to your database using PHPmyAdmin? If so, look at the posts table, do you see any of your post titles?

  5. carrollw
    Posted 3 years ago #

    I'm using the latest version of WordPress.

    The trash must be empty, I don't see that list.

    I'm not much on PHP. Do I need to go to Hostgator to get into the PHPmyAdmin or thru WordPress???

  6. cubecolour
    Posted 3 years ago #

    Yes you will need to go into your hosting control panel for that, but if you've never used PHPmyAdmin before you will need to be comfortable with what you're doing before starting.

    It may be better to attempt a db repair anyway - ie assume the problem is with the database being corrupted. To do this follow the directions in the codex: http://codex.wordpress.org/Editing_wp-config.php#Automatic_Database_Optimizing

    It would be prudent make a database backup before carrying this out.


    define('WP_ALLOW_REPAIR', true);

    to your wp-config.php
    go to your_site_url/wp-admin/maint/repair.php

    Then remove the line you added from the wp-config.php

  7. carrollw
    Posted 3 years ago #

    Thanks for all your help. I've got it fixed now.

  8. cubecolour
    Posted 3 years ago #

    Great! was that the problem or was it something else?

  9. carrollw
    Posted 3 years ago #

    I use HostGator for web hosting, so this is how I fixed it.

    Go to HostGator cpanel and log-in

    1. Go to MySQL Databases (not MySQL Database Wizard). Click it.

    2. Go to Modify Databases (under Create New Database)

    3. Look for "Repair DB"

    4. Choose the blog number from the dropdown list

    5. Then click on the "Repair DB" button

    It was a lot easier than I thought it would be.

    I don't know how other web host are set-up, but this is how it works with HostGator.

    Thanks for all the help.

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.