Transfer members from one database to another

Hello,

Is it possible to transfer members from one database to another? If so, what tables do I get the info from?

It's possible but you need to ask yourself this:

- Is there any modifications that have been done that affect Profiles?

- Is both databases created for the same version of Dolphin? (ex. 7.1 > 7.1)

- Do you also want to transfer members content (photos, videos, etc.)

If you JUST want to move the members, you can do it by transferring the Profiles table. Keep in mind, that members will not have avatars unless you move that directory too.

 Zacron,

Thanks for your guidance. I am transferring from users that is 7.0.2 to 7.0.9. I have many issue with my 7.0.2 install that I do not think and I just want to start from scratch. Are the tables very different? I'd just like to transfer their profiles and avatars. Do I just export and import them or do I have to do it manually?

I can start from scratch with all other content.

You stated that you want to import to a 7.0.9 site. Any particular reason you do not want to go with the current version 7.1?

7.0.2 > 7.0.9 is quite a jump. I am pretty sure there are database differences. How much when it comes to the Profiles table, I am not sure of. But here is what you can do to test it.

MAKE A BACKUP OF BOTH DATABASES FIRST

1 - Install a 7.0.9 (or 7.1) version of Dolphin (clean install).

2 - Go into your PhpMyAdmin, open the 7.0.2 database.

3. Click the Profiles table on the left

4. In the right window, you should see an export tab. Click that

5. Choose to save the file as a .sql file

6. Go to your PhpMyAdmin in your 7.0.9/7.1 site.

7. Open the 7.0.9/7.1 database

8. Click the profiles table on the left

9. Here you have 2 choices - 1. You can paste the contents of the SQL file withing the SQL tab and run it or 2. Click the import tab and browse to your .sql that you saved and load it that way.

Worse case scenario, the import/SQL fails in the 7.09/7.1 database. Just restore it back with your backup.

I didn't see a download link for 7.1... only 7.0.9... plus the template I'm using is only for 7.0.9.

Ok. I will give it a shot. Do I do the same with the avatars?

I tried copying one of my profiles as a test and it worked, but wouldn't let me log out and the notification emails went through all over again. I worry that all my members will get this notification again.

The download for 7.1 is on the front page. They call it a 'trial download' but it's 7.1. Anywho, not sure why you couldn't log out and why you received an email notification. Makes no sense.

Avatars are in a 'folder' that needs to be moved.

Can anyone else jump in regarding password related issues. Is there any changes in Salt for example?

As far as i know. There is no difference between 7.0.2 and 7.0.9 as far as passwords go.

However the avatars require more than just the profiles table and the avatar folder.

The table bx_avatar_images will also be needed.

I am looking up table differences for the Profiles table between 7.0.2 and 7.0.9 now.

You Rock Deano! But of course you already know this.

Ok. The 7.0.2 and 7.0.9 Profile table is the same. Only difference would be modules that add fields to the profile table.

Example. Boonex version of facebook connect for 7.0.2 added a field to the Profiles table. The 7.0.9 version does not.

Other 3'rd party mods may also add fields to the profiles table such as my facebook connect module.

So if only the avatars are being moved then i recommend ALL modules on the 7.0.2 site except for the avatar moduled be uninstalled before exporting the Profiles table.

Then before importing to the 7.0.9 site only the avatar module should be installed. All other modules should remain uninstalled until import is complete.

Yeah.. What he said ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Oooooh... I didn't realize that. I will download 7.1 when I get the new template.

Now... can't I just reference my old database when I install 7.0.9? That would be the easiest thing... but not sure if that would work either.

Overall, I'm just afraid that all the issues I have with my 7.0.2 install would carry over if I go through the entire upgrade process.

BTW... thanks deadon92964 and Zarcon. I really, really appreciate your help on this.

deadon92964... wow! I didn't even think of that. Ok. I will try this a little later on tonight. Wish me luck. I will let you know how it goes.

Although the Profiles table may have not changed since 7.0.2, I'm sure others have. I would not recommend referencing your older 7.0.2 database as it more than likely will not work if you do not do the full upgrades properly.

I Agree with Zarcon. You can't do that.

The profiles table is the same, but there are plenty of other tables that are different. So no. It will not work.

Question: would it better then to update to 7.0.9, import the users, then upgrade to 7.1?

Yay!!! Deadon92964 and Zarcon it worked! You guys are super awesome! Thank you for ALL of your help and knowledge sharing :)

Because he is just importing profiles and avatars and the needed tables are the same even in version 7.1, you could jump all the way to 7.1 using this method.

I have the same request but from 7.1.6 to 7.2 

i saw that "profiles" table structure changed, how can i transfer them safely

How would I move my entire database with members pictures and videos to another site.

IMHO the simplest way would be to:

1. take a DB dump
2. import the DB on the new server
3. go to the "clustering" documentation on Boonex, to look at what videos, sounds, etc get shared
4. copy those over to the new server
5. if you want to synchronise your files between old and new, use rsync (or similar) to perform

There may be other options, like some web hosts have cPanel or other panels which allow you to backup the entire server and restore the backup onto another server with the same web panel, but your questions seems to specifically relate to certain items to move.

If the requirements is specifically for x,y,z only and leaving the rest, that can become more difficult as you then need to know tables within the DB to move. Much harder.

When I tried it only the profiles appeared on the other site not the pictures or avatars.

These would not be stored in the database. Look in the online documentation, especially the section for clustering, as that lists directories for where the media is kept.