Akeeba Backup for Joomla!

Wednesday, 18 September 2013 07:00 CDT

activha

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.14
PHP version: 5.4.17
MySQL version: 5.5.31
Host: AWS
Akeeba Backup version: 3.8.1

EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 2Mb, please upload it on your server and post a link to it.

Description of my issue:
With latest version 3.8.1 it is impossible to save the DB, all was working fine with 3.7.xx
I have managed to save the files only of the website but DB always hangs
Log is attached

Wednesday, 18 September 2013 07:17 CDT

activha

I have checked that we have more than 120 000 rows in a table and that akeeba backup only hang at about 20 000 rows for this table after 45 mn !

Except removing it from the backup is there any other steps that I can do ?

Thanks

Wednesday, 18 September 2013 08:55 CDT

nicholas

Please go to Configuration and check the Database Dump Engine selection. It should read "Native MySQL backup engine". If not please click on the drop-down and select "Native MySQL backup engine", then click on Save & Close.

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, 18 September 2013 09:15 CDT

activha

This was already the setting selected. Nothing has changed between version 3.7.xxx and 3.8.1, we just did the automatic upgrade.

Thing is that we sent a newsletter to our 100 000 subscribers, then the table acymailing history is now much bigger.

Here is a screenshot attached with my settings for the DB

Wednesday, 18 September 2013 09:24 CDT

nicholas

The problem I see is that from one point onwards your MySQL server needs 15 seconds to send us the contents of one database record. It only happens on the main site's database, not any of the add-on databases which makes me suspect something. Please edit your site's configuration.php. Find this line:

public $dbtype = 'mysql';

and change it to

public $dbtype = 'mysqli';

(note that mysql becomes mysqli with an extra i at the end)

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, 18 September 2013 09:41 CDT

activha

I just tested it but it seems still very very slow, launched the backup 10mn ago and it still hangs when saving the main site DB

In Amazon RDS we have mysql(5.5.31) for engine, are you sure we need to put mysqli in the config ?

All three DBs are hosted on the same RDS server

Wednesday, 18 September 2013 09:44 CDT

activha

I also have the message :
DB Instance xxxxxxxxx (main site DB) contains MyISAM tables that have not been migrated to InnoDB. These tables can impact your ability to perform point-in-time restores. Consider converting these tables to InnoDB

Can I safely convert all tables of joomla to MyISAM according to you ??
Could it be a problem for backup ?

Wednesday, 18 September 2013 10:47 CDT

nicholas

Can you please follow my advice and switch mysql to mysqli in configuration.php?

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, 18 September 2013 10:49 CDT

activha

sorry I was not clear enough, I already followed your advice and switched mysql to mysqli before trying another time with the same results as explained above.

The backup of the DB still hangs after about half an hour....

Wednesday, 18 September 2013 10:53 CDT

nicholas

Can you send me the new backup log file so that I can compare it with the previous one?

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, 18 September 2013 11:00 CDT

activha

here it is

Wednesday, 18 September 2013 11:11 CDT

nicholas

It's the same issue: the database takes way too long to dump the records. At this point I would strongly suggest to repair and optimise your database tables using phpMyAdmin. This kind of performance degradation in your database is deeply abnormal.

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