I would say that your host doesn't know jack about how they server works. First off, Akeeba Backup doesn't produce SQL files, it produces archives.
Second, the archive files were created successfully. As a result, their claim about "bad .sql files" doesn't hold more water than a baloon with a 2" hole.
Third, the problem was not in the backup taking process, it was in getting the files to Amazon S3. They didn't even look at what the problem is before replying.
Fourth, Amazon S3 is the single most tested feature in Akeeba Backup. It uses PHP's cURL extension to contact Amazon S3 over their RESTful API and store the files. Hardly has anything to do with "bad .sql files"...
Fifth, the problem is NOT in Akeeba Backup's code, it is somewhere between PHP and Amazon S3. Given that hundreds of us use this on a daily basis without a problem, the only possibility is that their firewall cuts the connection to Amazon S3. Why do the suppose I have no problems with Rochen?
Sixth, cPanel backup (what they suggested) is not something you can easily schedule and you can certainly not use it to restore the site on any other server except the one it was taken from. The "questionable" backups are used by major template providers to provide installable sites and countless Joomla! professionals to move sites between hosts, between accounts and between live and local servers. You just can't do that with a cPanel backup. But, how could your host know if they just care about snatching your money instead of trying to provide support to their paying customers?
You would suppose a decent host would take a look at the problem and know all of the above, because it's their business to do so. You do pay them to do so. Instead, they didn't even look at any error logs and dismissed your claim with a -sorry for the language- BS excuse. I hope you're not paying them more than $2/month, because that's how much this inexistent customer support is worth. If you want me to provide you with a list of hosts who actually know what they are doing and can really help you when you have a problem with their service, I am more than willing to do so.
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!