Trying to restore WordPress site

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!
LVL 26
David BruggeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martyn SpencerManaging DirectorCommented:
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.
1
David BruggeAuthor Commented:
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.
0
Terry WoodsIT GuruCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David BruggeAuthor Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.