You can of course change the database connection information when restoring a site. It's part of Akeeba Backup's restoration script capabilities since its first version back in October 2006, some 14 years ago.
In the Restore Database page you can enter the new connection information for your database including the hostname, username, password and database name, as well as the table name prefix.
Since SiteGround moved to their own, proprietary site management interface (Site Tools) I cannot guide you where to find this information in your hosting control panel. You can, however, ask their support to tell you where to find this information. I can tell you with absolute certainty that entering the correct database connection information does work. We use that feature constantly: daily test restorations using the in-development code, restore client sites on our local machines when troubleshooting peculiar issues, restore our live sites on our local machines (even when using Akeeba UNiTE; it is a CLI interface to the restoration script stored inside the backup archive), update our live sites, move development sites between different development machines (I have two computers, a macOS one and a Windows/Linux dual boot one, both used for development as I need to test against all three major OS) and so on and so forth.
You will never need to do a MySQL dump and restore it manually when using Akeeba Backup. That's the whole point of it.
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!
