WordPress.org

Ready to get started?Download WordPress

Forums

deleted sql database (10 posts)

  1. donjz
    Member
    Posted 9 years ago #

    I recently re-installed wordpress from mywebsite.com/blog to the root directory mywebsite.com. When I uninstalled the prior installation of wordpress at /blog, it also deleted my sql database. I did back-up my previous wp directory by downloading a copy of the entire directory. However, I do not know if it included a copy of my blogs.

    What I'm trying to say is, I'm #&$(*ed-up!!! Does WP keep a record of blogs on the installed directory or are all the data stored in the sql database? If WP has a copy of the database on the installation directory, which I downloaded, maybe I'm okay. But if not, I'm in serious trouble.

    Can anyone advise?

    Thanks.

  2. ifelse
    Member
    Posted 9 years ago #

    All the data is stored in the database, but how exactly did you "delete" the database?

  3. donjz
    Member
    Posted 9 years ago #

    I did not delete it on purpose. My hosting company has this user interface where you can install and uninstall software. It lists the installations of wordpress, which I had three. One for my personal blog which I installed under mywebsite.com/blog, a new installation at mywebsite.com root, and another site for my friends. I clicked on "remove" for the /blog installation.

    When I went back to my website, I can't access it anymore.

    So, does WP has a copy of the database stored in the installation directory?

  4. moshu
    Member
    Posted 9 years ago #

    No, it doesn't. There is no "database" in the installation directory - only the WP files. Sorry, it seems you lost your blog.

  5. donjz
    Member
    Posted 9 years ago #

    NOOOOOOOOOO!!!

    In the future, can someone make sure that WP keeps a back-up of the database on the installation directory? It will surely help a lot of dingbats like me.

  6. moshu
    Member
    Posted 9 years ago #

    You can try to ask your host whether they have a backup or if there any way to retrieve it...
    And as for the future: next time do not rely on those "automatic" things, just use this tutorial:
    http://codex.wordpress.org/Moving_WordPress

  7. Glo
    Member
    Posted 9 years ago #

    donjz, how did you backup your wp directory? Did you happen to use cpanel to backup everything?

  8. ifelse
    Member
    Posted 9 years ago #

    donjz,
    It's not 100% clear that the database has been "deleted". The db resides in a totally different area from your web sites file area.

    If your database tables are still there, then if you reupload the WP files, then you should find that everything is back as it was i.e. all your old data is back. Before we panic, let's try that first, ok?

    "can someone make sure that WP keeps a back-up of the database on the installation directory?"
    Due to the way databases work, this is virtually impossible. What you must always do is backup your database.

  9. donjz
    Member
    Posted 9 years ago #

    Thanks guys. Bluehost.com has not replied to my inquiry about this matter. I guess, my database is forever lost. Anyway, I re-installed everything with a new theme Old Vigan that I designed (not from scratch though).

  10. ifelse
    Member
    Posted 9 years ago #

    Skippy's DB backup plugin was designed to help prevent this sort of stuff happening again in future.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.