[SOLVED] Suggested Migration of CBSub from 2.x to 3.x

I am looking at upgrading an existing Joomla 2.x site to 3.x and believe the best way to do this is to migrate rather try to upgrade.

My biggest concern is figuring out the easiest way to migrate the users and their CBSubs status/plans/history.

Other than using CBJuice to import users, I am not sure of any other tools available to help.

Am I potentially looking at rolling up my sleeves and digging into the database files?

AlexRag wrote: I am looking at upgrading an existing Joomla 2.x site to 3.x and believe the best way to do this is to migrate rather try to upgrade.

My biggest concern is figuring out the easiest way to migrate the users and their CBSubs status/plans/history.

Other than using CBJuice to import users, I am not sure of any other tools available to help.

Am I potentially looking at rolling up my sleeves and digging into the database files?

Not sure why you believe best way is to "migrate".

Joomla 2.x to 3.x should be much easier to do using the joomla upgrade process.

I would first backup and clone.
Upgrade to latest CB/CBSubs/Other CB Add-ons you have on your J25 site.
and then do the joomla upgrade.
Test everything on the cloned site and if things seem ok, then repeat the process on libe site.

Hi Nick,

I've had unpleasant experiences in the past doing the seemingly simpler upgrading, but found I spent more time dealing with outdated or incompatible extensions causing issues (not yours, of course ) I feel a fresh start would be a better approach. That being said, I would certainly try the upgrade path first.

I just wanted to be prepared for the alternative which is to migrate in case things don't go well. My only real concern is keeping/rebuilding the user account/CB Subs part. Most everything else in the site can be rebuild from scratch. At this point, I don't know if this path is much more complex.

Thanks,
Alex

After making several failed attempts to upgrade from 2.528 to 3.5x using Joomla Update I've decided the best approach is a fresh install.

So this brings me to looking at how to migrate the user data and CBSubs data from one site to another. If I recreate all the configuration settings (like CB subs plans) is it possible to deal with the migration by just updating the tables in the database or are there other steps that I should be looking at?

My main concern is to rebuild the CB/CBsubs data. Everything else in the site can be rebuilt manually.

The main concern for CB and CBSubs data moves is ensuring IDs match. If you move all of CB and CBSubs tables then things like plan id, basket id, etc.. will all match. The next major concern in that case would be User ID. Those absolutely need to match or all relations with a user are lost (data, subscriptions, etc..). Users you should be able to export/import easily with CB Juice or directly moving the relevant Joomla tables.

CB and CBSubs configurations are database based so they'll all move when you move the table data.

In the case of a fresh install, would I be better off not making any config changes (like plans, plugins, etc) in the backend and then just copy over all the CB tables?

Thanks for the tip about the user id's. I think moving the user tables might be be a safer solution. I guess I would need to make sure I copied over all the correct tables..

I better brush up on my MySQL skills. Might be an interesting ride.