Transfer Joomla User Accounts From One Forum To Another,?
August 3, 2009 under FAQ
Hello,
I was wondering if it is possible to transfer the joomla user accounts that are on one site to another, if it is possible, how?
I expect you can do it using phpmyadmin etc etc i was just wondering if anyone had any experiance doing it.
Thanks
Search more about Transfer Joomla User Accounts From One Forum To Another,?:
Yes I did. Cpanel>phpMyadmin then select the database.
Export and select all then save as SQL file extension.
Import to the new phpmyadmin just as the previous step.
Transferring a database from one site to another is the same, regardless of the code using it - in phpmyadmin, export the database to a file. Move the file. In the new database use phpmyadmin to import the file.
If you’re “moving” it from one database to another on the same MySQL installation (meaning you’re moving it to another database), change the database name in the file before you import it. It’s a text file, so just edit it.
I’ve done this a few times.
***HAD TO EDIT*** - Forgot a table.
FOUR tables are involved. (using default Joomla table prefix of jos_ )
1. jos_users
2. jos_groups
3. jos_core_acl_aro
4. jos_core_acl_groups_aro_map
Phpmyadmin is indeed the easiest way, export those tables from old and import to new.
HTH - good luck
-Aaron