Support

Hi,

I created a Jomla site in a VM on my computer, and would like to move it to my real site.

First time I tried, I had an issue and found out on the documentation that I need to create a database first. So I did it but did not succeed. I was always told it's not possible to connect to the database.

So I have these questions:

• Should I name the created database the same as in the backup to restore ?
  Should the user/password be the same as in the backup ?
  Should I use the same collation as in the backed up database ?
  Should I use the same prefix ?

I just don't get how to properly create that empty database.

Please note that I have cPanel on my site.

Many thanks

Gilles Plante

Creating your database is a little beyond the scope of our support because the process varies from one host to another. Your host's support staff should be able to help you with that. It may also be in your host's FAQ, since it comes up on a regular basis.

You do not have to use the same database name, user name or password for your new database. You will be prompted for all of those details during the restore of your site. The old information may show up as defaults, but can be changed.

Some hosts use the host account user as a prefix for the database name. So if your host username is "foo" and you create a database "bar" the actual name of the database is foo_bar.

Most hosts use "localhost" for the URL of the database, but not all of them. GoDaddy in the long gone by used to use an IP address. Some others use 127.0.0.1.

As you can see, the difficult bits are in the host specific details.

Thanks Dale,

to sum up I create a new database (empty) and then kickstart will restore the database from that backup into tyhe newly6 created database.

With cPanel I can create a Database users and MySQL users. Which one is needed to restore the database - my guess is MySQL user ? cPanel is version 86.0.18.

By the way, should I use the same table prefix as in the database to restore or is Genie will take care of differences ?

Thanks again

Gilles,

Technically, Kickstart is just the extractor. When the extraction is complete, Kickstart hands off to ANGIE, which is the restore script. The distinction is important sometimes because you upload Kickstart and can change the version, ANGIE is embedded in the backup archive and the version is dependent on the version of Akeeba Backup that you used for the backup.

In answer to your question, yes, Kickstart/ANGIE will restore the data and tables to the empty database.

You want to create a database user and assign all rights to that user to the database you just created.

No, you do not have to use the same table prefix as you used previously. ANGIE will assign a new, random table prefix during the restoration. You can change the random string to the old prefix if that is important to you.

Hi Dale,

thanks a million for your support !

With your latest answers I was able to restore my site flawlessly. Even my contact page worked first time !

Your procedure is incredible, letting us set everything from within it.

I am so glad I picked akeeba backup.

Have a good day !

You're welcome! I'm glad it all worked out.

Stay safe!