Support

Akeeba Backup for Joomla!

#42236 restoration failure - kickstart-pro-8.0.6 on backups taken by Akeeba Backup Professional for Joomla!™ 10.0.5

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
5.3.3
PHP version
8.3
Akeeba Backup version
10.0.5

Latest post by nicholas on Monday, 01 September 2025 00:29 CDT

JanDerhake

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 10MiB, please upload it on your server and post a link to it.

Please help!
My Partner has the same issue on his environment. We cannot restore!

nicholas
Akeeba Staff
Manager

I’d like to remind you that Akeeba Kickstart’s role is solely to extract the backup archive – it does not perform a full site restoration. The current version, Kickstart 8.0.6, works perfectly with backup archives created by Akeeba Backup for Joomla 10.0.5. In the month since the release of Backup 10.0.5, I have personally used Kickstart 8.0.6 to move dozens of sites across several development and testing environments, and even to restore a live site without issues.

To help us pinpoint the problem you’re experiencing, could you please share a little more detail? Specifically:

  • What exact steps you are following when you run Kickstart.
  • Any error messages or warnings that appear, and the exact wording of those messages.
  • Whether the issue occurs during extraction, after extraction (e.g. when using the Backup Restoration Script), or at another stage.

With that information we’ll be able to guide you more effectively and get your site back on track.

Looking forward to your reply.

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!

JanDerhake

Thanks for the fast replay!
Okay i did missunderstand this.I forgot that Angie skript is included by Akeeba Backup.

The problem occures, when restoring the database. Even when I deleted all tables by hand before.

Incorrect table name '' SQL=DROP TABLE IF EXISTS ``

Strange message...

here, also as screenshot   I don't know what I am doing wrong. Using your software since years without problems.

nicholas
Akeeba Staff
Manager

You probably have a malformed table name in the backup. Try disabling "Stop on CREATE error" and "Stop on other error" in the Database Restoration page.

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!

JanDerhake

I already did this, same failure message.

nicholas
Akeeba Staff
Manager

Please upload a copy of your backup archive file(s) to Dropbox, OneDrive, Google Drive or something similar. In your next reply please paste a public share link (not password protected or requiring authorization) so I can try to restore it locally and tell you what is going on.

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!

JanDerhake

Ah okay, you switched to private ticket. So no security reasons ;)

Thank you for your help. I am happy that there are still programmers trying to solve problems!

Here the link to the Backup on my own nextcloud:
https://derhakecloud.de/index.php/s/ffRPCrZBGCkyG4Z

Regards,
Jan

nicholas
Akeeba Staff
Manager

You have a pretty messed up database, but we can work around that.

After extracting the backup archive and before pressing the "Run the installer" do the following.

Edit the following files under the installation/sql directory:

  • site.sql
  • site.s05
  • site.s06
  • site.s16
  • site.s27
  • site.s59

In each file replace the following (some files may only have one instance of one replacement, others may have multiple instances of either or both replacements; make sure to replace all instances of the following replacements):

  • ``#__content`- with `#__content-
  • ``#__categories`- with `#__categories-

Go back to Kickstart and click on the "Run the installer" button.

When you are in the Database Restoration page, look at the right hand pane. Enable the "Select which database items to restore" option. A new area opens below.

Click on Add All to select all entries. Then, deselect the following items by CTRL-clicking the following entries:

  • #__categories-DaSi-20250729-2153(orig)
  • #__categories-DaSi-20250730-1534
  • #__categories-DaSi-20250731-1711
  • #__categories-DaSi-20250731-2337
  • #__categories-DaSi-20250731-2346
  • #__categories_Dasi-20250801
  • #__categories_copy
  • #__categories_test
  • #__content-DaSi-20250729-2153
  • #__content-DaSi-20250729-2210
  • #__content-DaSi-20250730-1534
  • #__content-DaSi-20250731-1704
  • #__content-DaSi-20250731-1711
  • #__content-DaSi-20250731-2337
  • #__content-DaSi-20250731-2346

Then proceed as normal. Your site will restore just fine.

I would like to point out two things.

First, DO NOT try to create copies of core Joomla tables such as #__categories and #__content. It won't work. Joomla also creates corresponding entries in the #__assets table, but this table's entries cannot be managed by hand, and are tied to everything in Joomla – including installed extensions. Copying core tables around is at best useless. If you try restoring them (renaming them back) it's worse than that; it breaks your site in subtle ways which make it misbehave, break core and third party extensions, and break Joomla core updates. 100% of the update issues I have ever seen are, in fact, caused by someone doing table juggling like you did. While this kind of database abuse worked perfectly fine in Joomla 1.0 (which became EOL in 2007) and to some extent in Joomla 1.5 (which because EOL in 2012) it has not worked since Joomla 1.6!

Second, DO NOT use anything other than lowercase Latin letters without accents or diacritics (a-z), numbers, underscores, and dashes in database table names. Other characters may or may not work. Most definitely DO NOT use backticks (`), single quotes (') or double quotes (")! These characters have special meanings in MySQL. Including them in a database table name does cause a certain amount of problems in database management software. We try to work around these issues but some cases, like yours, cannot be fully addressed without breaking the behaviour in other, more frequent use cases.

I hope that helps.

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!

JanDerhake

Thanks a lot for your help.- I think this will solve the problem.
I will try later on. And I now seem to know what did the cause the database failures.

You really saved my week. I already was afraid of starting from (nearly) zero!

As I was forced to go deeper into J5 and its database, I really learnt a lot...

I will follow an take good notice of your notes!

 

If you want to, you can put this ticket back to public, so other people perhaps can learn from it!
(the download link is deactivated)

Again thanks a lot.

Jan

nicholas
Akeeba Staff
Manager

Thank you very much! I will be making this ticket public.

Have a fantastic week!

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!