Support

Akeeba Backup for Joomla!

#8432 Error in running backup with additional databases

Posted in ‘Akeeba Backup for Joomla!’
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

Joomla! version
n/a
PHP version
n/a
Akeeba Backup version
n/a

user8364
I am having the same issue with 3.0.b2, but it only happens if I specify an additional database in "Multiple Databases Definitions". I am trying to specify my Coppermine database. If I "test connection" it is able to connect but when I try to run a backup with the extra database specified I fail with message:

AEAbstractDump :: Database Error: No Database Selected SQL=SHOW TABLES

The log file at time of error has:

DEBUG |100504 19:11:55|Closing SQL dump file.
DEBUG |100504 19:11:55|----- Finished operation 41 ------
DEBUG |100504 19:11:55|AECoreDomainDb :: Iterating next database
DEBUG |100504 19:11:55|AEDumpNative :: New instance
DEBUG |100504 19:11:55|AEDumpNative :: Processing parameters
DEBUG |100504 19:11:55|AEDumpNative :: Finding tables to include in the backup set
DEBUG |100504 19:11:55|AEDumpNative :: Starting CREATE TABLE and dependency scanning
DEBUG |100504 19:11:55|----- Finished operation 42 ------
ERROR |100504 19:11:55|Failed Smart algorithm on AECoreDomainDb
DEBUG |100504 19:11:55|Kettenrad :: More work required in domain 'PackDB'
DEBUG |100504 19:11:55|====== Finished Step number 2 ======
DEBUG |100504 19:11:55|*** Batching of engine steps finished. I will now return control to the caller.
DEBUG |100504 19:11:55|Sleeping for 1810.82510948 msec, using usleep()
DEBUG |100504 19:11:57|Saving Kettenrad instance

If needed I will create an ID on this site for you to use to debug this issue. Thanks for your help.

Ken

nicholas
Akeeba Staff
Manager
Before you create an account, let's try the basics.

Are you sure the credentials to the extra database are correct, i.e. the Test Connection returns successfully? It may sound silly, but I plea guilty of having done that quite a few times in the past :) Edit I just realized you already said that the test connection works. So scrape that, proceed with the next step please.

Then, please ask your host if they allow multiple database connections inside the same script. When the backup is running, Akeeba Backup will need to have one database connection open to the Joomla! database (actually, Joomla! does) and open yet another database connection to the extra database. If your server only support having a single db connection open, we're out of luck.

If all else fails, create me an account and I'll debug it on your server.

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!

user8364
Hi nicholas,

Thank you for the prompt reply!

According to the support forum information I found for my web host provider (HostMonster) there is no limit on MySQL connections.

Also, I have successfully done this in the past with JoomlaPack but switched to Akeeba because I believe people who put in the effort to make such a quality product should be compensated for it! Anyway, the ability to successfully do this previously with JoomlaPack tells me it is probably not an environmental issue unless Akeeba's architecture is completely different.

Any other thoughts?
Ken

nicholas
Akeeba Staff
Manager
Ken, I have uploaded a new [uhttp://www.akeebabackup.com/developer-releases/02-akeebapro.htmlrl=http://www.akeebabackup.com/developer-releases/02-akeebapro.html]developer's release[/url] which should address the MySQL connection problem. Please try using it and report back your results.

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!

user8364
Hi nicholas,

No joy on the svn131 code. I don't know if this is critical or not: When I installed svn131 I got the message that installation was successful, but I also received an error message saying:

JInstaller::install: File '/home2/myuser/public_html/tmp/install_4be2bd306843c/media/plugins' does not exist.

Other than that, I received the exact same symptom as previously. Hmmm, I was unable to attach the log file, so I put it akeeba svn131 log here.

Cheers,
Ken

nicholas
Akeeba Staff
Manager
Can you send me a PM (or an email to nicholas -at- akeebabackup -dot- com) with login credentials to your site? I will really have to debug it directly on the server.

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!

user8364
Email sent.

Ken

nicholas
Akeeba Staff
Manager
Ken, thank you for the email with the credentials and sorry for the long time to reply. The last 3 days have been busier than I expected. The problem is not with the backup code, they are with the connection testing code. More specifically, the connection test will report a successful connection even if you have mistyped the database name. I mean that it only checks the host, port, username and password fields; it doesn't check the database field!

So, you had simply entered the wrong name for the database. Why? You didn't understand what the prefix means. The prefix is the database table name prefix, not the database name itself. For example, the database name is foo_bar. There's no prefix. we don't care if you have a dash in there. Tables can have the form gallery_images, gallery_users etc. The gallery_ part of the table name is the prefix. It should be more clear once you read the documentation ;)

As you can see I changed that on your live site and it is completing the backup operation successfully.

It goes without saying, if you have further questions do not hesitate to post back here.

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!

user8364
Ouch! Many thanks Nicholas for correcting the problem, and apologies that it turned out to be specification error. I actually am a manual reader, but assumed I was not in error since I was getting an "OK" from the connection test.

Anyway, all appears to be working properly. Again, thank you for your help.

Ken

nicholas
Akeeba Staff
Manager
I think the biggest part of the problem was the misleading result of the connection test. If it worked properly, it would have triggered your seeking and reading of the manual page and solving this issue much more quickly :)

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!

Support Information

Working hours: Typically we work Monday to Friday, 9am to 7pm Cyprus timezone (EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets, but we cannot respond to them, outside of our working hours.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!

Summer vacations: Our support will be closed for replies and new tickets from August 6th to August 21st, 2022 due to summer vacations.