Support

Dear Don,

Creating a database on your server, restoring the database content and extracting the backup archive are three entirely unrelated things. Please let me explain.

You only need to extract the backup archive once. After it's extracted you can relaunch the restoration script (ANGIE) anytime by visiting the installation/index.php URL of your site on your browser. For example, if your site (where you are restoring to) is http://www.example.com you can visit http://www.example.com/installation/index.php to get to the restoration script. Just keep in mind that you will need to remove the backup archive, the installation directory and kickstart.php yourself after the restoration is over.

Regarding the creation of a database, this is NOT done through ANGIE. This is something that you usually have to do through your hosting control panel. Please consult with your host. What you need to move forward is the database server hostname (typically "localhost" on SiteGround), the database username and password and the database name. We can't tell you what these are since we're not your host.

Having this information you can now proceed to the restoration. When you reach the database restoration page you must enter the database hostname, username, password and name in the field provided BEFORE asking ANGIE to restore your database. If you've got the information right the restoration will go on without a problem.

Since you're using SiteGround and we're also hosted on SiteGround I can give you some more specific information. Please go to https://www.akeebabackup.com/documentation/troubleshooter/abidatabase.html and read the information under "Creating a database on a cPanel host" to learn how you can create a new database on SiteGround (they're using cPanel as their hosting control panel). Do keep in mind that questions regarding the creation of databases and database users should be addressed to your host. Maybe they've already created one for you and don't allow you to create a new one. Unfortunately these are the critical bits we just can't know because we're not your host.

You have entered the wrong database connection information.

When the database does not exist –but the hostname, username and password are correct– ANGIE assumes that you need to create the database. This is when it issues the command you pasted. Since your database user has no privileges to create a new database you get a failure message.

Almost every single time I've seen that message it means that you did create a database, you did create a user, but you didn't give the user access to the database or you didn't give the user all the necessary privileges. I'm pretty sure SiteGround didn't check for that.