How can I selectively import the latest posts from the old site into the new one?

Unfortunately, there is no easy way to import the latest post from your live site to the development site, the quick way to do this is to drop all the Easyblog tables (#__easyblog_xxx) from your development site database, then re-import again your latest exported data (all the Easyblog table #__easyblog_xxx) from your live site database.

Okay... can you confirm which tables only contain the CONTENT as opposed to style and functionality?
As I say, I need to create and prepare the new envirnoment with new styling that I do NOT want to overwrite from tables that don't need to be migrated.

Hey there,

I am really sorry for the delay of this reply as it is a public holiday for us here.

Do you mean that which table suppose to store the blog content?

If yes, you can check the following tables:

- #__easyblog_post
- #__easyblog_revisions

Hi...

Coming back to this ticket.
We have EB 6.0.10 on a live site (Joomla 3) and about 6 months ago we created a new dev site (Joomla 4).
We created the dev site by cloning the live site and then successfully running the Joomla core update routine so at that point we had all the exact same data, users, content etc. in J4.
We then developed the J4 site with all the existing EB authors, posts, categories, etc. and created new styles, template, look and feel.
During the development (J4), the live site (J3) continued as live and the authors continued to post and is now a couple of hundred posts and a couple of new authors ahead.
Now we want to synchronise the dev site with all the EB content from the live site.
We tried to copy across ALL the _easyblog_ tables, and while that was successful, it overwrote all our dev work by breaking all the styles, layouts and templates.
So we need to know which tables we need to copy across that will ONLY update content (including authors, revisions, and anything else that is content-related) but NOT overwrite new styles and layouts.
Note... we have successfully updated all the Joomla user tables so live and dev are identical. Also, because it's a clone copy, the dev site database uses the same table prefixes.

Can you please help?

Thanks

Hey Nick,

May i know how you imported to Joomla 4 site? Which table you imported?
Please elaborate in details, so we will be able to assist you.

My first attempt used ALL tables from J3EB6.0.10 > J4EB6.0.10 but some tables broke our dev since we changed a lot of settings and theme choices in the new version.

I've been looking at the tables and I'm thinking of these:
xxx_easyblog_acl
xxx_easyblog_acl_filters
xxx_easyblog_acl_group
xxx_easyblog_adsense
xxx_easyblog_category_acl
xxx_easyblog_composer_blocks
xxx_easyblog_configs
xxx_easyblog_favourites
xxx_easyblog_featured
xxx_easyblog_feedburner
xxx_easyblog_languages
xxx_easyblog_media
xxx_easyblog_meta
xxx_easyblog_oauth
xxx_easyblog_post
xxx_easyblog_post_category
xxx_easyblog_post_tag
xxx_easyblog_ratings
xxx_easyblog_reactions
xxx_easyblog_reactions_history
xxx_easyblog_revisions
xxx_easyblog_subscriptions
xxx_easyblog_tag
xxx_easyblog_users

Are there any critical tables I missed?
I left out any empty tables.

Note: I deliberately excluded the xxx_easyblog_category table as the J4 version has an extra category that we need since ACYmailing no longer recognises EB's "Frontpage" when building automated newsletters, so we needed to create a dedicated category instead.

Hey Nick,

As you want to copy the content only the tables you copied are fine.
Can you tell us what kind of error you are hitting?