How To Transfer Site From Host A to Host B Using Akeebabackup - Include Data To The Backup

Article Index

Include data to the backup

[Note] Note

This feature is available only in Akeeba Backup Professional, the paid version of our component

By default, Akeeba Backup automatically includes the whole database of your Joomla!™ installation as well as all the files under your site's root in the backup set. Sometimes you want to include a different database - for example, one used by your non-Joomla!™ newsletter software - or files you have placed above your site's root for increased security. Akeeba Backup Professional can cope with that need by providing you with handy data inclusion filters.

Multiple Databases Definitions

[Note] Note

This feature is available only in Akeeba Backup Professional, the paid version of our component

Sometimes your site grows beyond Joomla!. A forum, a torrent tracker, a custom script... Some of them get to be installed in a database of their own, not as tables in the same database as the one Joomla! is using. If you really want to take a full site backup, you really need these databases backed up as well. The solution to this is the Multiple databases definitions option of Akeeba Backup. You can define an unlimited number of additional MySQL, PostgreSQL, SQL Server and Windows Azure SQL databases which will get to be backed up (and restored!) along with your regular Joomla! database.

[Warning] Warning

Do not use this feature to add your site's database. It is automatically added anyway. Doing so will cause errors during the restoration of your site! You have been warned. Do not seek support for this kind of issues.

[Warning] Warning

Do not confuse the term "database" with your Joomla!™ tables. It is possible that a single database contains tables for the current Joomla!™ site, tables from a standalone photo gallery script, tables from another Joomla!™ site on the same server (e.g. a subdomain), tables from a standalone PHPList installation and so forth. As far as Akeeba Backup is concerned, all of those tables exist in the same database. Unless you tell it otherwise, it will backup ALL tables of the database.

A common misconception is that if you want to also backup a subdomain running on Joomla!™ and having its tables inside the same database as the main site, you should add its database a multiple database definition. DO NOT DO THAT, IT WILL MAKE THE RESTORATION FAIL! After all, Akeeba Backup already backs up those tables. Why should you have to back them up a second time?

[Warning] Warning

If you add an empty database (one which has no tables) it will result in backup errors!

[Note] Note

The settings on this page are defined per profile . Make sure you have selected the desired profile in the Control Panel page.

At first, you are presented with a grid view, listing all database definitions. On the left of each entry, there are two icons:

  • The trashcan. Clicking on this icon will remove the current database definition from the backup set.

  • Pencil or Add. Both will open the database definition editor: the former to edit the database definition, the latter to create a new one.

The database definition editor opens as a dialog box inside the multiple databases definitions page. The options you can select for each database are:

  • Database driver. You can select which database driver Akeeba Backup will use to connect to the database. Your options are:

    • MySQLi. This is an improved MySQL 5 connection driver. We recommend using it for MySQL databases.

    • MySQL. This is the regular MySQL connection driver for PHP. It has the widest compatibility, but the lowest performance.

    • PostgreSQL. Connection to a PostgreSQL database.

    • SQL Server. Connection to a Microsoft SQL Server database. You must be running your site on a Windows server and have the Microsoft-supplied "sqlserver" PHP extension installed.

    • Windows Azure SQL. The same thing as "SQL Server". Windows Azure SQL databases are, in fact, Microsoft SQL Server databases running in a remote machine. You must be running your site on a Windows server and have the Microsoft-supplied "sqlserver" PHP extension installed.

  • Database server hostname. The host of your database server. Usually it's localhost, but many hosts use something different. If in doubt, ask your host.

  • Database server port. Leave it blank, unless your host has told you to use a non standard port for connecting to his database server.

  • Username. The username of the database user needed to connect to the database.

  • Password. The password of the database user needed to connect to the database.

  • Database name. The name of the database you are connecting to.

  • Prefix. The prefix used in the table name's prefixes.

    [Important] Important

    MAJOR PITFALL: Please do not leave the Prefix field blank if you intend to use the Database Table Exclusion feature to exclude tables or table data of this extra database from the backup. If you don't want to use a real prefix, please use a "fake" prefix, e.g. thisIsAFakePrefix_ , to keep the Database Table Exclusion feature happy and functional.

[Warning] Warning

Some hosts use your account name as a prefix for the database and username. This is not the same as the Prefix setting above! In fact, you have to incorporate that account prefix in your database and username values. For example, you're hosted under the account name foobar and you create a database mydata and a user myuser. Your host displays a prefix foobar_ on the left of the edit boxes where you entered the database and user names. This means that your REAL database name is foobar_mydata and your real username is foobar_myuser. This is especially true for accounts hosted in cPanel and Plesk powered hosts. It goes without saying that your password doesn't take a prefix!!! Don't laugh, this question has been already asked in the forum.

If in doubt, contact your host. We can't guess the right values for you because we are neither your host nor your host's client (that is, you). If you ask your host to give you the connection information to your database, they must be able to do so.

When you think you have all the connection information ready, click on Test Connection. This will check all settings except the Prefix. If the connection test succeeds, it will inform you:

Same goes if it fails:

If your connection works properly, it's time to save your changes by clicking the Save button. The top panel will briefly display a "loading" message and the dialog box will go away. That was it, your extra database definition is now saved.

SMS mobile app! New and existing users can easily use this app to reach family, friends and business associates by installing this app on their mobile phones.