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!