[SOLVED] Migrating user *data* (not users)

Hello!

I've done several searches on here and can't quite find the solution to my problem.

I recently upgraded my site from Joomla 1.0.9 to 1.5.22, and almost everything went well.

I was also able to migrate my basic CB users list safely using Joomla's standard migrator plugin.

So my users are in place, but all of their data is gone -- all of the fields and tabs I built.

This isn't a huge deal -- the community part of my site was never that popular -- but can anyone offer any guidance on how to port over their data? I've tried exporting and importing all the comprofiler tables via phpMyAdmin, but that doesn't work.

HUGE thanks in advance!!!

System info:

CB 1.3.1

PHP Built on: Linux ps24324 2.6.33.7-vs2.3.0.36.30.4
#23 SMP

Database Version: 5.1.39-log

Database Collation: utf8_general_ci

PHP Version: 5.2.15

Web Server: Apache

Web Server to PHP interface: cgi-fcgi

Joomla! Version: Joomla! 1.5.22 Stable

Post edited by: krileon, at: 2011/01/04 14:28

Sense you're not moving user data the easiest approach is to just use phpmyadmin and Export the database tables you want and Import them to the new database. Things such as Userlist, Tabs, etc.. are not user specific. I recommend exporting ALL of CBs database tables. Import the tables then delete all the user data (won't match up with _users so needs to be removed or migrated properly with CB Juice).

Krileon, thanks for the reply!

I've actually tried exporting and importing all of my CB database tables in phpMyAdmin, but it always breaks my new site.

Do I need to upgrade my old site's version of CB to the latest version before I export and import?

Thank you!

I've actually tried exporting and importing all of my CB database tables in phpMyAdmin, but it always breaks my new site.

Breaks your site isn't very descriptive. Probably something wrong with the export. You need to delete ALL of your CB tables before importing them or the IDs will conflict with one another.

Do I need to upgrade my old site's version of CB to the latest version before I export and import?

Both sites should be the same version.

OK, got it! Apologies for the vague language. I'll try updating my old site's version of CB and then give the migration another try.

Thanks again for your time!

Hi
Thank you for this information. Very helpful. I am about to do this and need some information.

I ran the migration script and created the new 1.5.22 site. It all went well with core user data being migrated. I installed CB on the new site and then synchronised the users. Of course all the user data is not in place.

My question is if I use CBJuice to move all the CB user data to the new site will it duplicate the members already there? Should I remove all users from the site as well?

If I created a new install of J1.5 with no users and then used CBJuice to import all the CB user data would this also populate the core Joomla users?

The reason I ask this is that I constantly have new members joining the old site so by the time I do a migration to a new site there are new users registered on the current site who will not be in the new site. I know I can take the old site offline while doing the migration but I would prefer not to and if it was possible to use CBJuice to populate core users I would not need to.

Any advice appreciated.

Regards
Mike