- This topic has 3 replies, 2 voices, and was last updated 1 year, 7 months ago by .
- You must be logged in to reply to this topic.
These forums are for general discussion on WordPress and Genesis. Official support for StudioPress themes is offered exclusively at My StudioPress. Responses in this forum are not guaranteed. Please note that this forum will require a new username, separate from the one used for My.StudioPress.
on April 19, SiteGround set up new PHP and MYSQL setups on their servers, I think that their scripts messed up my database. I cannot pin down the timing to that though.
portwingpleinair.com came up with an "unable to access database" error. The database settings in the config file did not match and I was able to edit them and the site is up now but now my Posts, Widgets, menus and Customizer are gone. Its like it is a new site. My site files are there though. Backups take me to this same situation.
Have you contacted SiteGround support? If they installed a new version of MySQL without copying over the old database, this is something they should fix. When MySQL is upgraded, it doesn't auto-migrate older data. This article is from a few years ago. It's about recovering MySQL tables after a MacOS upgrade. It's not relevant to me any more because I use MariaDB in my dev environment, but you may find some relevance to your situation. https://victorfont.com/recover-mysql-tables-after-upgrade-osx/
Also, what you may be able to do is restore your DB backup to a local instance of MySQL, some it and restore the dump file back to your primary server. It will take some effort and there's no guarantee it will work, but I would try.
Thank you for this information.
SiteGround support had me replace the database entries in the config file then told me that I have a theme or plugin problem when the posts, widgets etc were missing.
© 2022 WPEngine, Inc.