I redesigned an existing site using local. My credentials for local are different than my credentials for the live site. I created a backup of my local using WPvivid and uploaded to the live WordPress using WPvivid. When I restored the new design everything was successful but when I went to login with my online WordPress credentials it would not log me in. I tried my local credentials and they worked but the only user listed in WordPress was my local credentials. My online credentials along with the original admin was missing. The site worked fine from the editing side but once I went to a different device, the old site was still showing up. Please help me understand what happened. I ended up restoring the backup of the old site and it brought back my online user account and the original admin user account. Please help…I need to get this new site up and running. Thank you.
What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc
Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.
When you migrated the site you likely replaced the DB with the old one, and updated the users. On your live site, if you have SSH access you should be able to create or edit users if you want to add one or update a password. You can do the same in your Local environment if you wanted to create a different user instead of changing your primary one.
Just so I am absolutely clear. Is that the normal process when creating an updated site in local. Should I have created a backup from the old site and restored it to the new local version of the site so that the database remained the same and I would not have run into this issue? If this is the case, is there a way to take the pages menus etc from the new local site and use them to update the backup of the old site that is restored on local?
There are a couple of different issues here after re-reading your post.
You should be able to avoid login issues by just creating a different admin user if you want in Local and leaving your other one alone. That way if you move the site back the credentials for both will be in the database. Or you can just use the same user credentials in Local as the live site.
The site worked fine from the editing side but once I went to a different device, the old site was still showing up.
This is likely just a caching issue. Did you try flushing your cache and cookies, checking in a different browser, or incognito window? You might also need to check if you’re using any plugins or themes that store cache or have a Regenerate CSS option.
I cleared my browser cache and did try an incognito browser but the web address still displayed the old site. I’m thinking it was an issue with the server side cache. I ended up restoring the old site because I panicked. This morning I created a new local site and restored the old live site to the new local one so that the database was the same. Do you know of any way to just copy the pages, menus etc without changing the database. I just did a backup without the database included and I’m going to try to restore the copy I made this morning.
Yeah server caching could definitely play a part. I usually try to keep like a caching mental checklist and be sure I’ve checked server, browser, network, plugins and themes.
As far as database changes you could always export/import specific tables if you want. If you’re asking how to do this specifically with WPVivid I’m not familiar with their tools but they might have some documentation or support that could guide you there. In Local you can click on the Database tab and then Open AdminerEvo (the site needs to be started) and then use the native tooling there for example.