Forums

HELP! I "hosed" my WP database! (2 posts)

  1. hammerz
    Member
    Posted 4 years ago #

    I saw what I thoguht was an "extra" SQL data base on my server at Site 5 and deleted it. (Don't ask!) Fortunately, I had just backed up the SQL DB to my desktop computer. so, I thought that all I had to do was recreate the DB, reset the passwords to the previous ones and import the backed up files and I would be good to go. NOT SO!

    When I try to load my WP blog in my browser, I recevie the following message:

    Can’t select database
    We were able to connect to the database server (which means your username and password is okay) but not able to select the johnston_wrdp1 database.
    Are you sure it exists?
    On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?
    If you don't know how to setup a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

    Eveidently a connection between the SQL DB and my WP folder at http://johnstonz.net/chuckzblog2 is broken...but I don't know how to fix it.

    Any suggestions or direction that I should follow. should I completely rebuild the WP setup form the ground up and re-import my DB file?

    HELP!

  2. Andrew Ozz
    WordPress Dev
    Posted 4 years ago #

    Site5 has phpMyAdmin. Log in there and see if the db was restored properly. You can also try recreating the db from whitin phpMyAdmin depending on the type of backup you have.

Topic Closed

This topic has been closed to new replies.

About this Topic