Support

Akeeba Backup for Joomla!

#36573 Error in SQL File when exporting database only from Akeeba backup

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 chrishoefliger on Monday, 07 February 2022 08:41 CST

Monday, 07 February 2022 03:25 CST

chrishoefliger

Description of my issue:

This is about an error in the resulting SQL File, when you configure Akeeba Backup to export the database only. It is clearly the idea, that you have to use phpMyAdmin to restore a database tus exportet. However on import in myAdmin, several errors are notet (see attached image ab-error-1). Apart from that, the import runs through.

Analysing the exportet SQL file reveals what you can observe from attached image 'ab-error': This being a ready-to-use SQL file, it should contain prefixes for all tables. Which it does, with one exception: there's no prefix for table 'finder_taxonomy'.

Obviously hardly anyone uses backups in this way, but as the possibility is there, I think it's worth reporting.

Edited by on 2022-03-09 20:45 CST

Monday, 07 February 2022 08:36 CST

nicholas

Thank you for the heads up! There are actually two bugs here we didn't catch because, as you said, virtually nobody uses Akeeba Backup like that:

  1. Any filters which can add extra queries to the DB dump wouldn't have the #__ converted to the correct prefix. This is what was causing your reported issue.
  2. Any foreign keys, indices etc using the table name prefix would end up with #__ in the database dump instead of the name prefix.

The solution was rather simple: before writing the SQL statement to the file we need to check if it's a standalone .sql and go through the abstract prefix replacement.

The fix will be included in the next version of Akeeba Backup scheduled for tomorrow morning. It was a very timely bug report! Thank you :)

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, 07 February 2022 08:41 CST

chrishoefliger

Thank YOU very much indeed, Nicholas.Much appreciated!

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!