My site was in need of upgrading a few things - WP core, WPML, WooCommerce, plugins - so I got my core up to date 4.7.3 and my plugins including WPML (but I left WooCommerce as it was). At this point I did some basic testing, and all seemed OK, so I did a full backup using UpdraftPlus, which backs up everything including the database, to a remote Google Drive location. I've used this method to do backups/restores in the past and it's been OK. After this I went on to upgrade WooCommerce, which required a database update. After this, I tested my WooCommerce shop and it was a disaster - all my products were missing.
I thought I'd leave this for another day so I went to restore the full backup that I has created earlier. I did this from within wp-admin. Midway through, the site just crashed with a HTTP 500 error - front end and back. Fearing the worst, I went to my Google Drive, manually downloaded the zip files, extracted, then uploaded core and the plugins folder using FTP. After this I got "Error establishing a database connection" on the front-end, and "Can't select database" on the back-end.
The site is http://recordiaublinc.com
, and the back-end is http://recordiaublinc.com/wp-admin
- please see message in wp-admin for a fuller description.
To try to solve this I've logged into the phpMyAdmin, and restored the DB backup that I have over the current one. No change. Also I've tried renaming the current one, creating a new blank one, then diong the import, …