Site Restoration

#20974 Restoring additional database to new server

Posted in ‘Site restoration’

This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version

n/a

CMS Type

Other

CMS Version

n/a

Backup Tool Version

n/a

Kickstart version

n/a

Latest post by user85417 on Wednesday, 17 September 2014 11:35 CDT

Wednesday, 17 September 2014 08:06 CDT

user85417

Hi,

I have configured Akeeba to backup an additional database to the standard joomla database. This has CIVICRM data on it.

I then backed up thesite remotely to another server and restored it using kickstrat to a new server.

At no point was I asked anything about this additiona database, and it is not present on the new server install.

lease could you point me in the right direction to recover the additional database.

Thanks

Wednesday, 17 September 2014 08:14 CDT

nicholas

Please remember that extra database definitions are per backup profile (like all settings in Akeeba Backup), not global. If you configure an additional database in your backup it will ask you to restore it when restoring the backup.

Also note that a database is defined as a different database name (with the same or different database server hostname, username and password as your main site's database). If your CiviCRM tables are stored in the same database as Joomla!'s tables then you really have one database, just two different prefixes. In this case Akeeba Backup will backup and restore all tables (Joomla!'s and CiviCRM's) as part of its main site database backup and will not ask you to restore an additional database.

So, based on this information we have one of two possibilities:

1. You defined the extra database in one profile but backed up with another profile. In this case your CiviCRM database was not backed up. In this case you need to take a new backup with the correct backup profile.

2. The tables of Joomla! and CiviCRM exist in the same database. In this case all your tables were backed up and restored as part of your main site database backup and no further action is required.

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!

Wednesday, 17 September 2014 11:35 CDT

user85417

Thanks Nicholas

I hadn't realised that I needed to set up the duplicate database again on the other profiles that we are using.

I was asked to restore the additional database once I'd fixed that.

Support