HELP! Which DB tables to Transfer?

I'm feeling like an idiot this morning, so please forgive.

I'm taking the content from a live site and moving it over to a dev site to work on a few things, before BETA of the new system.

I am having a dickens of a time with FLEXIcontent and FLEXIaccess.

I have exported/imported the following tables:

style_content
style_flexiaccess_acl
style_flexiaccess_groups
style_flexiaccess_members
style_flexiaccess_nestedgroups
style_flexiaccess_rules
style_flexicontent_cats_item_relations
style_flexicontent_favourites
style_flexicontent_fields
style_flexicontent_fields_item_relations
style_flexicontent_fields_type_relations
style_flexicontent_files
style_flexicontent_items_ext
style_flexicontent_items_extravote
style_flexicontent_items_versions
style_flexicontent_tags
style_flexicontent_tags_item_relations
style_flexicontent_templates
style_flexicontent_types
style_flexicontent_versions
style_sections

I have also copied my template files and com_flexicontent directory to the dev site.

I can't get access to my content in the admin.

What am I missing?

THANK YOU for any hints you can offer!

*smiles*

I've been trying this every way I can, and no matter what I do, FLEXI is not recognizing the original structure as created.

Any help is GREATLY appreciated. I was hoping to get this dev site up this weekend.

Thank you. Merci. Grazie. Danke.

*smiles*

.
You also need the jos_categories table (for sure).

May also need the jos_groups table (not sure).

.

Sorry.

I am including _categories.

I have not included groups. I'll try that, and get back in a few minutes.

*smiles*

.
Just took a closer look.

In addition to the FLEXIcontent and FLEXIaccess tables . . .

FLEXIcontent also connects to:
jos_categories
jos_content
jos_sections
jos_groups
jos_users

FLEXIaccess also connects to:
jos_categories
jos_content
jos_sections
jos_groups
jos_users
- plus
jos_contact_details
jos_core_acl_aro
jos_core_acl_aro_groups
jos_core_acl_groups_aro_map

There are also queries which read/write from components, modules, and plugins.
I assume you are merging the tables with an existing installation so that should not be a problem.

.

.
Are you installing FLEXIcontent and FLEXIaccess first?
You should.
Some of the installation queries are also making changes to the components, modules, and plugins tables.

.

Yes, I am installing them first.

*smiles*

Thank you for your help so far. I'll bringing those in.

I'll report back.

That still doesn't do it. Something is being lost in translation.

I have 20+ sites to do this with, so figuring it out would be very helpful.

This time, I included the following tables:

style_categories
style_contact_details
style_content
style_content_frontpage
style_content_rating
style_core_acl_aro
style_core_acl_aro_groups
style_core_acl_aro_map
style_core_acl_aro_sections
style_core_acl_groups_aro_map
style_flexiaccess_acl
style_flexiaccess_groups
style_flexiaccess_members
style_flexiaccess_nestedgroups
style_flexiaccess_rules
style_flexicontent_cats_item_relations
style_flexicontent_favourites
style_flexicontent_fields
style_flexicontent_fields_item_relations
style_flexicontent_fields_type_relations
style_flexicontent_files
style_flexicontent_items_ext
style_flexicontent_items_extravote
style_flexicontent_items_versions
style_flexicontent_tags
style_flexicontent_tags_item_relations
style_flexicontent_templates
style_flexicontent_types
style_flexicontent_versions
style_sections
style_users

(obviously, I use style_ instead of jos_)

Any other thoughts? There are just some connections not being made.

The custom fields, categories and such are just not showing up. It seems bizarre.

I have copied not only the DB tables, but the actual files in:

administrator/components/com_flexiaccess
administrator/components/com_flexicontent
components/com_flexiaccess
components/com_flexicontent

Hoping there might be something in there.

I am thinking this could be an issue for others, so hopefully we can figure this out.

Thanks!

I forgot style_groups.

That's in there as well.

.
I am assuming that you are replacing everything in those tables.

Why not just backup the entire website?
Use Akeeba Backup to backup and restore.

.