best way to transfer database ?
By Alfonso Sicilia on Tuesday, 21 January 2014
Posted in Technical Issues
Replies 15
Likes 0
Views 792
Votes 0
Hi,
i would like to know if there's an "easy " way to transfer my easysocial settings / images / Users/ messages / ui customization and everything related to easysocial, into a new database, so far if i do transfer everything from one site to the next it seems to break, and so i have to restore the backup.

Is it a matter of just saving out the tables with the _easysocial extension in the db and import them into the new database or am i missing something else ?

Do you think it would be possible to use two different databases (one for joomla and one for easysocial? ) or is an insane idea?

I tried with the export import , but it seems to only import few options so far.

any suggestions?
regards

-a
Hello Alfonso,

It's advisable that you backup the database tables that has a prefix of jos_social_* . Then, backup the necessary folders and transfer them over
Mark
·
Tuesday, 21 January 2014 19:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for the help Mark,

should i just ignore the " joomla users" table then ? What im trying to do is to move my site into a new joomla installation and update, but would like to keep all the easysocial related stuff , community and everything related to it, so users can just log in with the same credentials , and still have their avatars, images and so on..


regards
-a
Alfonso Sicilia
·
Tuesday, 21 January 2014 20:12
·
0 Likes
·
0 Votes
·
0 Comments
·
You can't ignore the user's table because those user id's are mapped to Joomla user's. Without those id's there are no relation between the data in EasySocial and Joomla users
Mark
·
Tuesday, 21 January 2014 21:33
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you Mark , sorry but im just new to this "world", just to recap , the minimum requirements to have back the community as it was, are :

- Joomla user tables
- Jomla EasySocial Tables
- Easy Social Folders

?
Do you know of any plugin that might do the job "easily" ? (if any?)


regards
-a
Alfonso Sicilia
·
Tuesday, 21 January 2014 22:43
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

If you have custom user groups in Joomla, then you will have to migrate the Joomla usergroup tables and the mapping table as well.

You can browser the JED for a few migration tools but those only migrates core Joomla's table.
Jason Rey
·
Tuesday, 21 January 2014 23:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you for your help, i think i managed to do it reasonably easily :

- Backed up all the Database :

- Joomla user tables
- Joomla usergroup tables
- Joomla mapping table

- Jomla EasySocial Tables
- and Easy Social Folders in
=> Sitename/media/com_easysocial => avatars / badges / images / photos


so far seems everything in the right place..

Please advice if i have missed something ..

regards
-a
Alfonso Sicilia
·
Wednesday, 22 January 2014 06:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

That should be about it!
Jason Rey
·
Wednesday, 22 January 2014 09:42
·
0 Likes
·
0 Votes
·
0 Comments
·
ThankS!

Btw, i really can't get my head around this one last thing.

lets say i have two databases, with same tables (from two similar joomla install) but different rows and values into rows ( different users basically..)
If i want to get the users from one database, export them, and then import them into the second database, so i will have all the users combined together in one bigger database, how can i do this ? is it possible? so far the only way for me to write into the tables is if i first drop them, which is inconvenient since they will also delete the users that i would like to keep?
Im a bit confused, i tried every possible option on phpMyAdmin .. maybe there is another way?


regards
-a
Alfonso Sicilia
·
Wednesday, 22 January 2014 10:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

This is a bit dangerous because from 2 different databases, the user might have the same user id, in which might cause conflict.

This step will need to be done manually where, the data of #__users will need to be imported without the ID column. When the data is imported, a new ID will be assigned, and you will need to find all the tied "ID" to update to.
Jason Rey
·
Wednesday, 22 January 2014 10:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for the advice , indeed much more complex than i initially thought it would be .


regards
-a
Alfonso Sicilia
·
Friday, 24 January 2014 01:19
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Alfonso
Mark
·
Friday, 24 January 2014 01:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi

Does the procedure of copying the tables from one database to another also work if the move is from Joomla! 2.5 to 3.2? Is the table structure the same? If not, is there a way to do such a migration?

Kind regards
Stefan Zahnd
·
Thursday, 20 March 2014 16:00
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Stefan,

If you are just planning to migrate the tables that are from our extension, they are version safe. In other words you can move them from 2.5 -> 3.0 or 3.0 -> 2.5 without any issues but what you should be more concerned about is the users table in Joomla. Are they using the same id's?
Mark
·
Thursday, 20 March 2014 16:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark

Thank you! Moved the tables and moved the user (with J2XML) and everything works fine.

Best regards
Stefan Zahnd
·
Friday, 21 March 2014 13:29
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for sharing Stefan and glad that everything worked out fine for you
Mark
·
Friday, 21 March 2014 13:34
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post