It would be nice if you could transfer from one server to another.

Yeah, i've been thinking about it... Maybe I can do it for the next weekend.

Guess im screwed.. I need it tonight >__<

Anyways do you know a good way to tranfer one db to another that arnt on the same server?

I cant make both usernames the same. using the plesk control panel.

Is ideas?

I guess you're asking if you can merge two users into one with the hack.... Yes, you can :) See this post.

No,

What i have is 2 database

1/ the new one jokersnetwork
2/ the old one i want to merge into the above called old

The problem i have is that according my my host says that both databases cannot have the same username. So database 1 has username "jokers" which is what is in the config.php file and database no.2 has a username in phpadmin of "joker"

My question is how can i make this migration work? because my host says that using pleask (control panel) i cannot have the same database username for 2 different databases.

Below is the error i get

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: SELECT COUNT(*) AS count FROM old.user
mysql error: Access denied for user: 'jokers@localhost' to database 'old'

mysql error number: 1044

Date: Sunday 01st of December 2002 01:47:32 PM
Script: http://www.jokersrewards.com/forum/f...import_vb2.php
Referer: http://www.jokersrewards.com/forum/i...import_vb2.php


Any idea's or suggestions?

could you make a mass user merge for those names that have the [imported] tag

im asking cus I have 3500 members that have [imported] and i'll be sitting here for weeks doing it manually :)

thanks

Well... That's why you have to associate usernames before starting the users merge. It's a complicated process, but it's required...

Another option is to modify the script to automatically merge two users when they have identical usernames... It's possible, but it's not recommended because it could merge two different users into one.... tell me if this solution could work for you.

Ohhh sorry.... Now I understand you...

Unfortunately at this time it's not possible to merge two database without the same user and password. I'll try to release a new version with this ability for you guys.

i've already imported and have just over 3000 *[imported] users

could you right a script so merge all these automatically AFTER all the importing and merging has been done

the *[imported] needs to be source and * needs to be destination