Akeeba Backup for Joomla!

#29823 Backing up and restoring Joomla site with some database tables as "views" of antoher Joomla site.

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 on Thursday, 12 July 2018 17:17 CDT

Tuesday, 12 June 2018 08:47 CDT

Fredjet

Hi,

My question is a bit general but specific to my set-up.

I have two Joomla sites. Site A and Site B.

Since my sites share users, Site B does not have its own version of the following tables:
_session
_usergroups
_users
_user_notes
_user_profiles
_user_usergroup_map
_viewlevels

Instead, Site B has MySQL "views" with identical names that simply pull in all the data from Site A.

Because of this, I have problems maintaining an Akeeba back-up file on Site B that I can easily restore without it trying to replace the "views" with actual tables.

Any ideas on how I can achieve an restore-able file?

Thanks in advance.

Tuesday, 12 June 2018 10:10 CDT

tampe125

Hello,

sadly you can't: you'll always have to backup both databases and tables.
That's because views will be rebuilt after the database backup completes.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Thursday, 12 July 2018 17:17 CDT

System Task

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Edited by on 2018-07-12 17:17 CDT

Support