Don't panic. We're here to help. I know how frustrating restoring a site to a really bad quality host can be. More so when you do not have years of experience. I was in your shoes some fifteen years ago. Bear with me and I'll help you not only restore your site but understand why things are happening which will help you make more informed decisions about hosting in the future (trust me, this
will save your sanity).
can't restore the database, getting error message "Unable to connect to the Database: Could not connect to MySQL."
You have either not created a database OR you are entering the wrong connection details when restoring the site. In fact, this is so common that
I've written a step by step tourbelshooter. Typically your problem is either step 1 (which I talked about in my previous reply) or step 4 (because it's completely non-obvious in cPanel and Plesk - I have been frustrated by this myself when I started building sites fifteen years ago and their interface has not improved at all since then!).
Before doing that,
there's a small chance that it's related to your previous issue. Since you're uploading all files by FTP their ownership may prevent the web server from writing to them. This is something we extensively explain in the
How your web server works chapter of our documentation. That, compounded with a host that has an invalid session save path set up in their server's php.ini, would make the restoration script unable to "remember" the settings you entered and unable to detect that it cannot "remember" them either (because the host would be lying about the PHP session working). To cut a long story short,
give the installation/tmp folder 0777 permissions.
Please note that if changing the installation/tmp folder permissions worked for you there's a good chance that your restored site will NOT work unless you give 0777 permissions to the directories tmp, cache, administrator/cache and administrator/logs (Joomla's temporary, cache and log folders). This is NOT something related to our software, it's something related to a very low quality shared host. To be precise, it's an indication of a host using PHP as an Apache module instead of FastCGI. If that's the case I strongly recommend switching to a better host
for security reasons. Using PHP as an Apache module (mod_php) makes the server vulnerable: one hacked site has read access to every other site on the server, allowing a hacker who knows what he's doing to bypass your defenses and hack your site
even though you've done nothing wrong on your site.
I remain for your questions.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!