Support

Akeeba Backup for Joomla!

#13399 Main site database only (SQL file) creates empty files

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 Monday, 27 August 2012 14:08 CDT

Monday, 27 August 2012 00:35 CDT

user67498
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: (2.5.6)
PHP version: (unknown)
MySQL version: (unknown)
Host: (optional, but it helps us help you)
Akeeba Backup version: (3.6.3)


Description of my issue:
Hi,
Full site backup and All configured databases (archive file) work fine but Main site database only (SQL file) creates empty file.

The confirmation email looks fine.

Akeeba Backup has completed backing up your site using the front-end backup feature. You may visit the site's administrator section to download the backup.

The new backup was taken with profile #1. It consists of 1 part(s). The full list of files of this backup set is the following:

Monday, 27 August 2012 03:44 CDT

nicholas
When you're using the "Main database only (SQL file)" you are creating a special case of a backup. There is no backup archive, just a SQL dump file. This may be throwing off some parts of Akeeba Backup which are designed to work with archives. I don't think that the file is empty, it simply doesn't get listed in the email. If you to the Administer Backup Files page you should be able to see it there.

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!

Monday, 27 August 2012 04:09 CDT

user67498
If I schedule the backup the file is empty, but if I create the backup through Backup Now button the file is fine.

I have scheduled the backup through cron task.

Monday, 27 August 2012 04:15 CDT

nicholas
As long as you're using the same profile, it doesn't matter how you launch the backup (back-end, front-end, lite mode, command line CRON job, JSON API). So, how did you set up your CRON job? Can you give me the command line of the CRON job, replacing paths/passwords as this is a public ticket?

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!

Monday, 27 August 2012 04:22 CDT

user67498
php /home/XXX/public_html/cli/akeeba-backup.php >/dev/null 2>&1

If I set the backup type to Full Backup or All configured databases (archive file) it works without any problem.

Monday, 27 August 2012 04:40 CDT

nicholas
Can you try removing the ">/dev/null 2>&1" and paste here the result of the CRON job when the backup type is set to main site database only?

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!

Monday, 27 August 2012 06:53 CDT

user67498
I have tried with the same results.

I have attached a print screen of files.

Monday, 27 August 2012 11:09 CDT

nicholas
That was a very interesting bug which has to do with the way the Joomla! Platform (and the JApplicationCli we're using in the CRON scripts) differs in handling MySQL connections than the CMS. I have just uploaded a new dev release. Can you please install it on your site and verify that it's fixing the problem you were experiencing?

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!

Monday, 27 August 2012 13:13 CDT

user67498
I have tried it and works.

Thank you very much Nicholas!!!

Monday, 27 August 2012 14:08 CDT

nicholas
You're welcome!

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!