Support

Site Restoration

#12891 Update please

Posted in ‘Site restoration’
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

PHP version
n/a
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

Latest post by nicholas on Monday, 09 July 2012 02:10 CDT

UglyEoin
Hey,

Thanks for the excellent article which I have already given you praise for:
https://www.akeebabackup.com/documentation/walkthroughs/advanced-site-transfers.html

However, I think you need to update it. Since J2.5 there have been two more tables added for users. user_profiles and user_notes. I think they should be included in the exclusion list.

Would love to see notes on 3rd party components, I'm sure a few are very popular, I know some of mine are "must haves" for every installation.

For example:

Freestyle Support Portal
All ticket information is stored in the The *_fss_ticket tables. The *_fss_users table has the various permissions for each user. They are the only tables that have per user info in (apart from author information)

I'm sure you could get others, perhaps by user submission, as often we have to go to the developers and ask them, but it would be a decent place to pool our answers.

nicholas
Akeeba Staff
Manager
Hi Oliver,

The #__user_profiles table is already mentioned. #__user_notes wasn't mentioned as the article was written a few weeks before Joomla! 1.7 was released and this table was added in 2.5.0 if I recall correctly :)

Regarding third party components there are two entire paragraphs right below the core table names. With almost 10,000 extensions listed in JED it's impossible for me to provide full instructions for all of them.

I can't even add instructions for "the most common" because that definition is subjective. On my sites this means (inclusive and exhaustive list) JCE, Akeeba Backup, Admin Tools, Akeeba Release System, Akeeba Subscriptions and Akeeba Ticket System. Some people use K2, others use Seblod, yet some others use Zoo. VirtueMart and RedShop are also very common. I can quickly come up with a few hundreds of "common" extensions, each one with at least two major versions. Writing instructions for all of them is beyond a full time job: it's a very expensive task which begs for an editing team counting a couple of dozen experienced developers to write and test the instructions.

At best I could offer a wiki, but I don't think it will work. You are just the second person to get interested in something like that. Without a critical mass of contributors such an effort is doomed from the get-go.

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!

UglyEoin
I'm not asking you to do it, far from me to suggest such a mammoth task.

Some kind of a Wiki would be great though, or any other solution really. Obviously my first task is to go through the components that I use, but I would gladly submit any information that I find as I go, I bet others are doing the same.

I'm sure that if you had about 5 or 6 experienced users you could gather the information based upon JCE, Zoo, K2, and so on. Surely most people use only a choice of about 5 content editors/cck. Other than very specific things most people use a lot of the same stuff. Even ecommerce, although a lot more technical, I think there's probably only about 3 mainly utilised versions.

Regardless of critical mass, the Wiki would be a nice idea. Happy to help out when I have time if you would like me to. But only if you refer to me as Eoin (because that's my first name). :)

Thanks again for an excellent component. Would love to hear of a solution, or perhaps develop one myself if you think that would be a better option - obviously I'd ask you to link to whatever site I put up.

nicholas
Akeeba Staff
Manager
Hi Eoin,

Sorry about the name confusion, I'm a terrible guesser of first/last names :D

We do have a user-editable Wiki on our project page at Assembla. You can always create a free account at Assembla, become a Watcher of the space and create new Wiki pages. If you're willing to start working on that, I can add a link to the Wiki in the advanced site transfers article. What do you think?

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!

UglyEoin
Ok I think I've done it... add a link and I'll see how I go... it might be nice if you perhaps send an email out to people asking for community support or something? Or tag it on to your next email?

Your call, but I'll happily help where I can as I am already doing the work I may as well make it available for others on the extensions that I use.

nicholas
Akeeba Staff
Manager
I don't have a newsletter and my Privacy Policy states that I won't be contacting you by email unless you asked me to (e.g. support) :) Any way, I created the wiki page at https://akeeba.assembla.com/spaces/akeebabackup/wiki/3rd_Party_Extensions_Exclusion Thank you in advance for any information you'll be adding!

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!