Support

Akeeba Backup for Joomla!

#11569 Backing up only databases (multiple, incl. extra one) issue

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

Latest post by nicholas on Saturday, 17 March 2012 04:32 CDT

user59808
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? YES, https://www.akeebabackup.com/documentation/troubleshooter.html but could this be the problem for my issue? and this one: https://www.akeebabackup.com/component/docimport/akeeba-backup-documentation/include-data-to-archive.html#docimport
Have I searched the tickets before posting? YES, found one where a possibility of the web hoster not allowing two database connections on different servers at the same time could be the issue.
Have I read the documentation before posting (which pages?)? YES

120315 15:27:43] --------------------------------------------------------------------------------
[120315 15:27:43] Akeeba Backup 3.4.2 (2012-03-08)
[120315 15:27:43] Got backup?
[120315 15:27:43] --------------------------------------------------------------------------------
[120315 15:27:43] --- System Information ---
[120315 15:27:43] PHP Version :5.2.17
[120315 15:27:43] OS Version :Linux infong 2.4 #1 SMP Tue Jan 17 02:58:41 UTC 2012 i686 GNU/Linux
[120315 15:27:43] DB Version :5.0.91-log
[120315 15:27:43] Web Server :Apache
[120315 15:27:43] PHP Interface :cgi-fcgi
[120315 15:27:43] Joomla! version :1.5.25
[120315 15:27:43] Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20100101 Firefox/11.0
[120315 15:27:43] Safe mode :0
[120315 15:27:43] Display errors :
[120315 15:27:43] Error reporting :E_ERROR | E_WARNING | E_PARSE | E_CORE_ERROR | E_CORE_WARNING | E_COMPILE_ERROR | E_COMPILE_WARNING | E_USER_ERROR | E_USER_WARNING | E_USER_NOTICE
[120315 15:27:43] Error display :off
[120315 15:27:43] Disabled functions :
[120315 15:27:43] open_basedir restr.:
[120315 15:27:43] Max. exec. time :50000
[120315 15:27:43] Memory limit :90M
[120315 15:27:43] Current mem. usage :6360932
[120315 15:27:43] GZIP Compression : available (good)
[120315 15:27:43] JPATH_BASE :/administrator
[120315 15:27:43] JPATH_SITE :
[120315 15:27:43] JPATH_ROOT :
[120315 15:27:43] JPATH_CACHE :/administrator/cache
[120315 15:27:43] Computed root :

[...]

[120315 15:28:12] ----- Finished operation 108 ------
[120315 15:28:12] AECoreDomainDb :: Iterating next database
[120315 15:28:12] Closing SQL dump file.
[120315 15:28:12] AEDumpNative :: New instance
[120315 15:28:12] AEDumpNative :: Processing parameters
[120315 15:28:12] AEDumpNative :: Finding tables to include in the backup set
[120315 15:28:12] AEDumpNative :: Starting CREATE TABLE and dependency scanning
[120315 15:28:12] AEDumpNative :: Got database connection
[120315 15:28:12] AEDumpNative :: Got SHOW TABLES
[120315 15:28:12] AEDumpNative :: Got table list
[120315 15:28:12] PHP NOTICE on line 1077 in file /administrator/components/com_akeeba/akeeba/engines/dump/native.php:
[120315 15:28:12] Undefined variable: dependencies
[120315 15:28:12] AEDumpNative :: Processed dependencies
[120315 15:28:12] XXX AEAbstractDump :: Getting temporary file
[120315 15:28:12] XXX AEAbstractDump :: Temporary file is /homepages/323/htdocs/abackup/748c7695.sql
[120315 15:28:12] AkeebaDomainDBBackup :: SQL temp file is /homepages/323/htdocs/abackup/748c7695.sql
[120315 15:28:12] AkeebaDomainDBBackup :: SQL file location in archive is 91ADBBC3-db316104222.sql
[120315 15:28:12] AkeebaDomainDBBackup :: Deleting leftover files, if any
[120315 15:28:12] AEDumpNative :: Initializing algorithm for first run
[120315 15:28:12] ----- Finished operation 109 ------
[120315 15:28:12] PHP NOTICE on line 249 in file /administrator/components/com_akeeba/akeeba/engines/dump/native.php:
[120315 15:28:12] Undefined index:
[120315 15:28:12] PHP NOTICE on line 250 in file /administrator/components/com_akeeba/akeeba/engines/dump/native.php:
[120315 15:28:12] Undefined index:
[120315 15:28:12] PHP NOTICE on line 257 in file /administrator/components/com_akeeba/akeeba/engines/dump/native.php:
[120315 15:28:12] Undefined index:
[120315 15:28:12] PHP NOTICE on line 278 in file /administrator/components/com_akeeba/akeeba/engines/dump/native.php:
[120315 15:28:12] Undefined index:
[120315 15:28:12] PHP WARNING on line 278 in file /administrator/components/com_akeeba/akeeba/engines/dump/native.php:
[120315 15:28:12] array_key_exists() [<a href='function.array-key-exists'>function.array-key-exists</a>]: The second argument should be either an array or an object
[120315 15:28:12] Skipping dumping data of
[120315 15:28:12] Done dumping
[120315 15:28:12] End of database detected; flushing the dump buffers...
[120315 15:28:12] Database has been successfully dumped to SQL file(s)


Description of my issue:

- I have defined a new profile for only backing up the databases, the main one of the joomla installation and another one, not a joomla-db.
- Testing connection to the non-joomla-db works correctly
- In the Configuration, Backup Type is set to All configured databases (archive file)

After starting a backup and finished "successfully" (as noticed by akeeba backup pro), the archive is created and there are several files belonging to the joomla database and one more 91ADBBC3-db316104222.sql (see log file above) that should contain the mysql dump of the other database (or not?) but this file has 0 bytes length.

As you can see in the logs above, something goes wrong there (many notices - maybe not important - and a PHP warning)

What could be the issue or problem?
Do you need extra information?

nicholas
Akeeba Staff
Manager
Please ZIP and attach the entire log file.

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!

user59808
Here is the Log file (ZIP)

nicholas
Akeeba Staff
Manager
The problem I can see is that there are no tables listed on the extra database. Are you sure the configured user has the SHOW TABLES privilege for that database and that the database is not empty?

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!

user59808
Yes, you are right, there was a problem showing the tables with SHOW TABLES! Very strange, but that was the problem.

Thank you very much!

Maybe, you could or will catch such a case showing a message to the user in a future update o Akeeba Backup if you find that could be useful.

user59808
PS. You have made a great documentation! Real good work!

nicholas
Akeeba Staff
Manager
You're welcome! Unfortunately, there is no way to know the MySQL user privileges. In fact, in order to know the MySQL user privileges, you need to have the SELECT privilege on the "mysql" database, which kinda beats the purpose as regular users will never have that privilege. It's Catch-22. So, the only thing left for these rare cases is to fail cold and have you guys ask me what to do. Even if I documented it, nobody would read it because it's only natural to think that not backing up a non-empty database is most likely a bug, unless you know how to read the log. But if you were able to read the log, you wouldn't need to read the documentation or ask me, so there you have another Catch-22. I just accept it as it is and reply to the relevant tickets - besides, backing up third party databases is so rare, that this issue has only happened two times so far :)

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!

user59808
I understand and I had to ask google what this "Catch-22" is :-)
Thank you again. I think, you can close this ticket.

nicholas
Akeeba Staff
Manager
You're welcome!

Off-topic: Catch 22 is a very good book. It's also very popular and references by geeks to it are very common (like "Catch 22", "Major Major Major" and "Yossarian lives"). I recommend reading it if you have some time ;)

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: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

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!