Restore content from database

  • Resolved ice-j

    (@ice-j)


    10 years, 4 months ago

    Hi all,

    Due to a mistake in an operation, I have deleted one of the website I have. After a panic moment, I went through my backups and restored the theme and plugins successfully.

    However, all the content I have written is not there. I am not an expert (not even close) and I read around on this forum and found out that I could access the database (and content) I have created by logging in “phpMyAdmin”.

    I did so, and I found in one of the databases my lost content (or so it seems). I can see information about pics, links, posts and so on… but (of course) if I try to access the post link I get a “A page not found” error…

    Now the question is: How do I get these posts/data back in to my website? Is it all lost or am I missing a simple step?

    Thanks in advance.

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

  • wp-config.php needs to point to that database (which is not corrupt or hacked).

    Thread Starter ice-j

    (@ice-j)

    Hi, thanks for your reply.

    I had a look at the wp-config.php file and noticed that it was actually pointing to another database (thanks!). I have made some changes, but it gave me “Error establishing a database connection” message for few times.

    I played a little bit around, after reading online, and re-installed the wp website… the wp-config.php file is pointing now to the right database. I have all the plugins in there… however all posts are still missing.

    Additional note: If I go now to phpMyAdmin, I see in the same database a duplicate for each table (I guess I created this once I re-installed the website).

    Any suggestion on how to proceed?

    Thanks

    In your wp-config.php file, look for this line:

    $table_prefix = 'wp_';

    What you need to do is make sure that the prefix that’s there matches what it was on the old (existing) database tables, so if the prefix is db_ you’d have tables like db_posts, etc. If the prefix didn’t match what was there origianlly then WordPress will install the new database tables, and not use the existing ones like you want it to.

    Thread Starter ice-j

    (@ice-j)

    Catacustic –> Thanks! This solved the problem!

    Thanks guys. Really appreciated the great help received here and even if I have no real clue on how database and code work, thanks to your help I fixed my mistake! You guys are awesome! ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Restore content from database’ is closed to new replies.