Restoring database from phpMyadmin
I’ve read through several forum posts and searched google for an answer to this, but with no luck (also a lot of the relevant forum posts on this topic are quite old now)
My site was hacked recently, so as a precaution I backed up my database (from phpmyadmin) and deleted all wordpress files from my home directory.
I now have a backup of the database dating from a few days before the hack happened (just in case)
What I need to do now is this: Re-install WordPress in my home directory and then restore all the data (posts, pages, etc) from the backup of the database.
After reading several forum posts and blog posts about this, here’s what I’m currently doing:
I create a new, blank database, db user and password.
I edit config.php so it points to this new database, and make sure it has the correct prefix.
Install WP in my home directory.
Then I go to PhpMyAdmin and drop all tables from the new database.
I then restore to the database from the backup which I’d previously made from phpMyadmin.
When I then go to the domain of my website, it’s just a blank white page.
Many of the forum posts I’ve read on this suggest it’s a theme related problem and the way to fix it is to change the theme. However, I cannot do this as not only is the home page completely blank, but so are all the admin pages (dashboard, login screen etc)
Some other posts I’ve read suggest that it’s not necessary to run install.php after re-uploading the WP files and that I can just make sure config.php is pointing to the correct database and all should be fine. But this results in the same situation..
Anyway.. long post, sorry about that! But I wanted to clarify as much as what I’d already attempted before asking for help..
I hope someone can help out with this!
- The topic ‘Restoring database from phpMyadmin’ is closed to new replies.