Trying to restore WordPress site

David Brugge
David Brugge used Ask the Experts™
on
I am being treated for lung and brain cancer with imutheropy and radiation. I was unprepared for what a muddle the radiation would make of my brain but here I am in the thick of it trying to muddle on.
I am in the process of trying to delete and reinstall a WP site. I thought the easiest way to do it would be take advantage of the Softaculous scripts in my C-Panel.
I used the delete function and apparaently checked the remove directry remove database, remove database user. I then tried to rebuild the site using the settings in my wp-config file.
The Softaculous script did the uploads but generated an error saying there was already a site with this url (this is what I thought checking the three checkboxes would take care of.
I don't know where this url is stored. It is not in the site directry.
So I paniced and tried to do a full restore using the server's backup. The backup diirectry didn't list the site even going three weeks back. I suspect this is because I deleted the database user name and there is nothing to attach the stored data to.
I am besieged with headaches from every direction; files with duplicate names to forgotten passwords.
I would pull my hair out if it hadn't fallen out already!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martyn SpencerSoftware Developer / Linux System Administrator / Managing Director

Commented:
Firstly, David, sorry to hear about your health issues. I hope that the condition is rapidly brought under control and that you are feeling better soon. Good luck!

With regard to the issue you have, sometimes it is a good idea to take a step back from the situation and consider what you do have. Your Wordpress site will ultimately consist of the files that are served by the web server and a backing database. Naturally, you want the most recent versions of both of these. Are you able to locate the most recent database backup and the most recent files backup? From these you should be able to reconstruct a working site, provided the backups are intact and complete. I know that this is a bit like closing the stable door after the horse has bolted, but it is always a good idea to back up and carry out regular test restorations of important data so that you are able to (a) verify that the backup is complete and (b) practise for a more speedy recovery as you have already rehearsed the procedures.

I tend to find that using tools such as CPanel can get in the way more than assist, so do be aware that it may be better to consider some form of manual recovery and that someone who is very familiar with Wordpress configurations will be able to help you. I would certainly be happy to help if no one else is able to step forward and guide you here. I am not specifically a Wordpress expert, but I would more than likely be able to put together a working site for you if your backups are in any way complete.
I have the latest backup in sql.qz format. I have a copy of the upload directoy and the widgets directory as well as copies of wp-config and .htaccess. I think my first order of business is to get a datatabase user name reestablished with the site. I don't know what to make of the error that the domain name is already in use.
IT Guru
Most Valuable Expert 2011
Commented:
The wp-config.php file will contain the database name and database user name and password. You could use those to recreate a database and user of the same names, and then retry restoring the server backup.

Would the hosting business be able to help? It may be a quick job for them to do it.
Thanks to both. I did have to go to my  service provider to have them remove the url so that I could reload the software. My only remaining problem seems that I am pointing to the wrong database. I THINK i can get that streightened out easy enough.

Thanks again.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial