New Database for existing WordPress site

So What you exactly want? a new database for your existing site? or to remove some data from your database?

Sorry , Im pretty stressed so missed out what I actually want

Yes , If possible a new database for the existing installation?

Thanks for the swift response

James

If you have access to their WP admin area, install a plugin called Duplicator. This backs up the site and the database that the site is using.

You can then download the zipped site, extract, find the database. Then inport teh SQL file into the newly created DB on the new host. Then just change wp-config.php to match the new database and all should be fine.

your only hope is hosting guys retrieve the database. ask them to be quick else due to business downtime you might plan to move your business to a better/reliable host.

even if they dont, you have nothing to worry, your ex-employer did a half botched job of migrating and it is his responsibility in first place to move his website files off your server.

last resort for your ex-employee will be to recover website from google cache or waybackmachine.

@innuvo

I don’t have access to the admin , just get “Error establishing a database connection”

@laliz

Im trying my best , but they are not very helpful at all, 1&1.co.uk is the host

I must have botched the transfer as I did it , but I didn’t expect when I transferred the domain name and migrated the website that the database would stay in my account. I find it mental that 2 separate contracts in two different names can access a database on the other.

Im not totally savvy with all this especially when it comes to SQL

My options seem to be dwindling

Regards

James

ah , you didnt did it correctly.you have to shift Files and create a new Db,migrate old db and update values in wp-config file for it to work on new server. https://codex.www.ads-software.com/Moving_WordPress FYI

how big is website? if less than 10 pages you can try to restore it from google cache, else wait for Hosting guys to get a backup. in meantime put
“Down for maintenance” page on Ex-Employer’s website.

you mentioned updraft was active on the website , then you should have backups.

New database for the existing site will give you the fresh installed wordpress with the template changes what you set before.
If that is ok with you then you can go for that.
just create a new database and set all the details of new database at the wp-config.php

@laliz

Its not a huge website , How do I go about restoring from Google CAche? thanks for your help

@Thefastmedia

Thanks again for responding , can you explain the part “Template changes you set before” ?

Sorry , Im trying to juggle my day job and not get noticed so my head is everywhere at the moment

means the theme changes what you done in the file will be as it is but you lost all changes saved at the database.

check all indexed pages in google by using
site:www.mywebsite.com
replace https://www.mywebsite.comw ith your website URL

then get individual URL and input it here.
cachedview.com/

Thanks all, No cache in Google apparently so a little stuck

The hosting has washed their hand of it so need another solution.

I appreciate all the responses

Regards

James

if it was a static website , contact original guy who created it. might have some backup lying around somwhere. backup is your only rescue.

had similar situation where My Hosting friend wiped his server and a client asked me where the website went , had to restore from google cache. could recover only 80% still better than nothing though

Create a new site + pull content from https://archive.org + add content back to site manually. If there’s a lot of content, write a script to scrape archive.org + inject all pages + posts into new site.

Then turn on backups, so this never happens again.