F.schettino
Italian
On development site I make a lot of modifications: new Lists-Forms-Elements, but also new Elements and modified "Name" (consequently the database is changed) of elements in existing List-Forms.
In the mean time, on the live site people added and modified records.
Which is the best and more secure way to update the live site (without losing user data in live site and new/modified definitions of Lists-Forms-Elements from development site)?
Until now, I replayed on live site the same modifications made on the development, but it is very tedious.
I considered two solutions:
(In any case, put offline the live site)
Solution #1
- Import records in db tables filled by Elements from "live" to development.
(I have to pay attention to modified fields name)
- Substitute tables in db live from development db (modified as described)
Solution #2
- Update definitions of Lists-Forms-Elements (*), from development to "live".
- Use "Update database" in list of Forms.
What happens to new records, existing records?
(*) #__fabrik_elements, #__fabrik_formgroup, #__fabrik_forms, #__fabrik_groups, #__fabrik_lists, #__fabrik_joins, #__fabrik_jsactions, #__fabrik_validations
An other question: what does #__fabrik_form_sessions contains?
Thank you in advance for your suggestions.
In the mean time, on the live site people added and modified records.
Which is the best and more secure way to update the live site (without losing user data in live site and new/modified definitions of Lists-Forms-Elements from development site)?
Until now, I replayed on live site the same modifications made on the development, but it is very tedious.
I considered two solutions:
(In any case, put offline the live site)
Solution #1
- Import records in db tables filled by Elements from "live" to development.
(I have to pay attention to modified fields name)
- Substitute tables in db live from development db (modified as described)
Solution #2
- Update definitions of Lists-Forms-Elements (*), from development to "live".
- Use "Update database" in list of Forms.
What happens to new records, existing records?
(*) #__fabrik_elements, #__fabrik_formgroup, #__fabrik_forms, #__fabrik_groups, #__fabrik_lists, #__fabrik_joins, #__fabrik_jsactions, #__fabrik_validations
An other question: what does #__fabrik_form_sessions contains?
Thank you in advance for your suggestions.