Support

Akeeba Backup for Joomla!

#16575 Akeeba SQL database only - errors when fresh joomla and database is connected

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 poplewebdesign on Monday, 01 July 2013 03:39 CDT

Friday, 28 June 2013 09:28 CDT

poplewebdesign
Joomla! version: 2.5.11
PHP version: 5.3.22
Host: Xilo Communications
Akeeba Backup version: 3.7.6 Pro

There is an issue with my Joomla and want to backup the core SQL database fields (i.e content, menus and categories etc.) and add this database to a new fresh installed joomla database.

However, when I backup the SQL and dump it into the new database I can see that the tables have copied across but the menu items do not work - it errors the SQL table number and the returns a 404.
I think this is because the table numbers havnt been preserved and when it comes to the menu items linking to articles the table number is wrong.
Is this correct?
If so is there a way to preserve the table numbers/IDs?

If not do you know why this would be happening?

Thanks in advance.

Rowan

Friday, 28 June 2013 09:50 CDT

nicholas
Hello Rowan,

You cannot do what you are trying to do, sorry. Categories, articles, components, modules, plugins, templates, core components' contents (e.g. weblinks, banners, newsfeeds) and menu items are all linked together in the assets table which is linked with the user groups table to which the users and viewing access levels are linked to. It's all so interconnected that you're trying to do has zero chance of success.

It's easier to clone the site using Akeeba Backup and remove what you don't want from the new site.

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, 01 July 2013 03:39 CDT

poplewebdesign
OK, thanks for a swift answer.

As always - great products and great support.

Cheers
Rowan

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!