I have a small wordpress site that was hosted on a VPS and I decided to cancel the VPS a few days before the expiration and move to a cheaper provider as the blog was not getting a lot of visitors.
However because I did my backups in a hurry, I accidentally backed up the MySQL table instead of the actual wordpress table in MySQL. When I decided to restore the site yesterday, I noticed that and unfortunately my previous VPS has passed the expiration and my old provider confirmed that once the VPS is destroyed, they can no longer restore the data.
I do have the entire backup of the wordpress folder and my understanding is that the MySQL table is mostly just storing the settings and user info for Wordpress. So I was thinking if I could do a fresh install of Wordpress and populate the table in my new MySQL DB, and then replace everything by the backup copy of wordpress folder that I have, I should be able to get everything to work.
However when I tried that, I ended up having a blank page and nothing else. My PHP log weren't giving any error either.
Any suggestion?