I solved part of this using the settings in J2XML to "keep user ids" for exported users. But J2XML won't let me import/export super users -- I'm the super user and most of the EB posts are written by me so this is an important step in EB migration. Do you know how to change the user id of super user? Thanks!

Hi Daniel,

There is no easy way to change a user's id number.

But J2XML won't let me import/export super users

Perhaps you can try the following?

1. Create new super user account on old site.
2. Temporarily change the other super user account to normal user.
3. Export and import all users to new site with J2XML.
4. Login as the super from step 1, and change the normal user back to super user in new site.

Great idea! That seems to have worked. I'll continue with the EB migration as outlined and let you know if I hit any snags. Thanks!

Alright Daniel. You're most welcome.

Hi, I followed the EasyBlog migration steps outlined in link above, but it didn't work. The database in phpMyAdmin of new site (ArtCareerFinder.com) is showing the 100+ migrated EB posts, authors, categories, etc. from current site (ITCareerFinder.com), but the Joomla frontend and backend are showing the data from the previous install (I previously had EB installed on ArtCareerFinder.com with only 1 post, and that's what's showing - see https://www.artcareerfinder.com/brain-food/blog.html) - Which is weird because I uninstalled EB on ArtCareerFinder.com and dropped all of its database tables before performing the migration steps and reinstalling EB. I've cleared all caches etc. Can you help me diagnose why this didn't work? Thanks.

Hey Daniel,

Can you provide us the back-end, ftp and database access for the new site so we can investigate? You may edit the starting post and add them into the site access area.

Ok I added access credentials for new site (ArtCareerFinder.com) in Site Access area. Lmk if you need anything else. Please avoid make any changes to the live production site (ITCareerFinder.com). Thanks!

Thanks Daniel.

I tried logging in siteground but there's a security verification where they sent a code to your email. Can you provide us the authentication code?

Ok I added the code to Site Access area. Thanks.

Hey Daniel,

I don't see the code. Maybe you can edit the starting post in this thread and add there instead?

Here it is again - 588123

Thanks Daniel. I managed to access siteground.

I checked the database and noticed the name is different than the one on your site(attached).

I'm not sure how you previously setup the database on the new site or where it's currently hosted, but I believe it's supposed to connect to the database on siteground.

****, I see what you mean, but I can't determine where I messed up. Yes, everything is hosted on SiteGround and you can see it all with those credentials. Is there anything you can try or suggest to get the database with all the EB posts (dbqigsxjbutoc3) to sync with ArtCareerFinder? I just tried to update the database settings in global config but it didn't work.. kicked me out of site and I had to restore the latest backup to fix it. Or should I inquire with my host? I'm backed up if anything breaks. Thanks.

Hm. If you enter the database information on your JoomlaFolder/configuration.php file and save, does it work?
These are the lines involved. If it doesn't work, may I know what is the error you encountered?

	public $user = '';

	public $password = '';

	public $db = '';

The current db ArtCareerFinder site is linked to is under medcareerfinder(attached). Not sure if that is what you intended.

Entering the db info in configuration.php broke the site. Error on both front and back end was "Error: Failed to start application: Failed to start the session."

Yeah it got confusing, ArtCareerFinder (ACF) was a copy of MedCareerFinder (MCF). And I'm now entering the data from ITCareerFinder (ITCF) into ACF (which I'm using as a staging site for ITCF) because I need to update the framework from Gantry 4 to Gantry 5, before I can update to Joomla 4 and PHP 8. And G4 and G5 are incompatible so it has to be done manually. Somewhere in this process my database wires got crossed.

So yes I think you're correct. I migrated EB data to the wrong database. Unless you have a better idea, I'm thinking I should get my database situation figured out and then try again to migrate EB data to the proper database. Which I'll do tomorrow since its 3am here.

Either way thanks for your help in diagnosing this!

Got the site pointed to proper database and the migration went smooth. Thanks again.

Thanks for updating us on the issue Daniel. Glad to know the database issue is resolved and the migration went smooth.

Regards.