Support » Fixing WordPress » How To Get WordPress Posts Back From MySQL!

  • Resolved chatty24


    So, by mistake I just overwrote my WordPress website. And it all started over again. Just One “Hello World” Post!
    So, I want to ask that, can I get my WordPress posts back(I don’t have a backup) from MySQL Database or by any other way?
    Have I lost it all :'(
    Please Reply!

Viewing 5 replies - 1 through 5 (of 5 total)
  • That all depends upon how you “overwrote” it 🙂

    To end up with “Just One “Hello World” Post!” means you are using a different (new) database (that’s where all your posts, among many other things, are stored).

    So if you do did in fact delete the original database without backing it up first, then yes, you have in fact lost it all.

    Contact your host as they may be able to roll back the site to it’s original version from one of their backups.

    So, Here is what I did!

    I transferred a new domain(from godaddy) to my host(ipage). Both of the domains were pointing to home directory and I was no knowing that.
    So, I installed a fresh copy of WordPress on the domain that I transferred. And later, I came to know that a new copy of WordPress is made in both the domains because both were pointing on the same folder.
    I can see my plugins and themes but not the comments and posts! 🙁

    My host is saying that database is already in the account!
    But I ca’t locate it. I have about 10 databases here!

    If you have a copy of your original ‘wp-config.php’ file, you can look for these lines:

    /** The name of the database for WordPress */
    define(‘DB_NAME’, ‘my_uname_mywpdb01’);

    /** MySQL database username */
    define(‘DB_USER’, ‘my_uname_mydbase01’);

    The DB_NAME is the name of your original database that holds the posts you are looking for. The data (posts) and all other content should still be in that database.

    Thanks To Both Of You!
    My Host Restored It For Me! 😀

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘How To Get WordPress Posts Back From MySQL!’ is closed to new replies.