[MySQL] How to import a column from db1.table to db2.table
 

Hello,

I've just downgraded my forum from vb4 to vb3, and would like to keep the "thanked" amount from old db. I looked into the old db and notice that "thanked" is a column in "user" table.

So i would like to ask how can i move (or copy) that column from old database into the table of the new database?

Also, is there anyway to plus 1 value in the "userid" field (of that column)? Because of i've used ImpEx and it's created a new admin with userid = 1, then my old admin account has userid = 2.

Thank you.

You'd have to create a new column with the exact datatype like the original column (if that istn't already done) then you'd have to create a php script, that queries every user row, builds a new query with updated userid (+1) in the WHERE clause to apply the sql query.

Could look something like this:

The function will return an array which you'll run through in a foreach loop, then you run a query for every user:

Depending on how good your knowledge in php is, this will be a quite simple task.

I have ran this query in phpmyadmin and it's ok, but only for the user who has id=2, how to loop it?
Sorry because my php knowledge is bad.

This is the query that i have used:

it's no mysql query at all :)

there needs to be a php script built around this...
Can you tell me if the two vbulletin installations are stored in the same or in a different database?
And tell me how the exact name of the column is where the amount of thanks is stored.

Two forums are store in 2 different databases. I wrote as 'vb4forum' and 'vb3forum' as above.
And the 'thanked amount' column name is post_thanks_thanked_times

Could you create a sample php page?

This is my old convert-youtube script. I just adjusted some values and added a 2nd database.

This only works if username and password are the same for the 2 databases.

open the file, enter your credentials at the top of the script. It works like
$db1 reads, $db2 writes. So $db1 is your old db to read from, $db2 is the one where you want the thanks transferred to.

Upload it into the root dir of your site (not forum root) so it can be accessed like "http://someurl.tld/transferthanks.php"
and run it.

didn't test it myself, if you're getting errors, report back. And I suggest to test it in a safe environment first.

Thank for the file but when it's got error:

Line 34:
Line 41:

d'ouh, my bad.

Fixed

Got this error:

For the whole from id 1 to id 509 (i have 509 users) and nothing change in database.

huh weird... change line 42 from:

to:
And post what the first error is, thanks.