WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] How To Get WordPress Posts Back From MySQL! (6 posts)

  1. chatty24
    Member
    Posted 11 months ago #

    Okay!
    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?
    Or
    Have I lost it all :'(
    Please Reply!

  2. 2ninerniner2
    Member
    Posted 11 months ago #

    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.

  3. chatty24
    Member
    Posted 11 months ago #

    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.
    Now,
    I can see my plugins and themes but not the comments and posts! :(

  4. chatty24
    Member
    Posted 11 months ago #

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

  5. RoamingPro
    Member
    Posted 11 months ago #

    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.

  6. chatty24
    Member
    Posted 10 months ago #

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

Reply

You must log in to post.

About this Topic